Diff mode was set to SVN, but /root/clickhouse-freebsd/databases/clickhouse is not a svn working copy.
Trying /usr/ports ... found
===> Generating patch
===> Viewing diff with more
diff -ruN /usr/ports/databases/clickhouse/distinfo ./distinfo
--- /usr/ports/databases/clickhouse/distinfo	2017-10-06 21:23:08.000000000 +0300
+++ ./distinfo	2017-10-25 18:07:48.663094000 +0300
@@ -1,5 +1,3 @@
-TIMESTAMP = 1505601351
-SHA256 (yandex-ClickHouse-v1.1.54289-stable_GH0.tar.gz) = 2804653b1dc3f0ba2f650d26f56421d81f0d0e35a05d821786608883a8c5a44d
-SIZE (yandex-ClickHouse-v1.1.54289-stable_GH0.tar.gz) = 13026512
-SHA256 (19042816c4a1.patch) = 99d844d6d968c3793b221796f0cb5eca40629d551866287b6c60acf46f0ad3ee
-SIZE (19042816c4a1.patch) = 994
+TIMESTAMP = 1508863744
+SHA256 (yandex-ClickHouse-v1.1.54304-stable_GH0.tar.gz) = 98ec354b700de8837ec25d691e70688cbae495b5e7a14da98b5adbaa77034cf0
+SIZE (yandex-ClickHouse-v1.1.54304-stable_GH0.tar.gz) = 12995159
diff -ruN /usr/ports/databases/clickhouse/Makefile ./Makefile
--- /usr/ports/databases/clickhouse/Makefile	2017-10-06 21:23:08.000000000 +0300
+++ ./Makefile	2017-10-25 18:07:48.663022000 +0300
@@ -2,16 +2,13 @@
 # $FreeBSD: head/databases/clickhouse/Makefile 451394 2017-10-06 18:23:08Z jbeich $
 
 PORTNAME=	clickhouse
-PORTVERSION=	1.1.54289
+PORTVERSION=	1.1.54304
 DISTVERSIONPREFIX=	v
 DISTVERSIONSUFFIX=	-stable
 #DISTVERSIONSUFFIX=	-testing
-PORTREVISION=	3
+PORTREVISION=	1
 CATEGORIES=	databases
 
-PATCH_SITES=	https://github.com/${GH_ACCOUNT}/${GH_PROJECT}/commit/
-PATCHFILES=	19042816c4a1.patch:-p1
-
 MAINTAINER=	proler@gmail.com
 COMMENT=	ClickHouse is an column-oriented database management system
 
====> Cleaning up
===> Done