Comments on: PostgreSQL: Access ClickHouse, One of the Fastest Column DBMSs, With clickhousedb_fdw https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/ Thu, 01 Feb 2024 00:40:17 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: nishitshah https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10972761 Thu, 08 Oct 2020 12:04:59 +0000 https://www.percona.com/blog/?p=55995#comment-10972761 Does it support Postgresql 12 and 13? If not, then expected time line to make it work with Postgresql 12 and 13.

]]> By: Ibrar Ahmed https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10970860 Tue, 04 Jun 2019 06:20:41 +0000 https://www.percona.com/blog/?p=55995#comment-10970860 Please create an issue with detail error message, I will look at that.

]]> By: Magnus Brun Falch https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10970859 Tue, 04 Jun 2019 06:17:58 +0000 https://www.percona.com/blog/?p=55995#comment-10970859 Could you please provide some more details?
I’ve tried Ubuntu 18.10/19.04 and Centos7. Couldn’t get it to run out of the box.
Tried setting up a dev environment but no files matching the name of the .so file in the documentation were produced by the make install step.
I’m working on a more exhaustive dependency list for Centos7 that would make getting started a lot easier for someone who hasn’t tinkered with building extensions for PostgreSQL before.

]]> By: Konstantin https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10970851 Fri, 31 May 2019 12:30:42 +0000 https://www.percona.com/blog/?p=55995#comment-10970851 is it possible to see datatype array(string) via clickhouse_fdw?

]]> By: Ibrar Ahmed https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10970839 Tue, 28 May 2019 20:54:46 +0000 https://www.percona.com/blog/?p=55995#comment-10970839 @xiatian, Please create a issue on the Github, I will respond on that.

]]> By: xiatian https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10970823 Fri, 24 May 2019 06:42:07 +0000 https://www.percona.com/blog/?p=55995#comment-10970823 why my test cannot push down,the follwing is my case：
PostgreSQL 11
OS: Centos

postgres# explain (analyze,verbose) select count(year) from ontime;
QUERY PLAN

Aggregate (cost=0.00..0.01 rows=1 width=8) (actual time=31441.737..31441.737 rows=1 loops=1)
Output: count(year)
-> Foreign Scan on public.ontime (cost=0.00..0.00 rows=0 width=4) (actual time=13.313..30108.858 rows=17189046 loops=1)
Output: year, quarter, month, dayofmonth, dayofweek, flightdate, uniquecarrier, airlineid, carrier, tailnum, flightnum,
originairportid, originairportseqid, origincitymarketid, origin, origincityname, originstate, originstatefips, originstatename, o
riginwac, destairportid, destairportseqid, destcitymarketid, dest, destcityname, deststate, deststatefips, deststatename, destwac
, crsdeptime, deptime, depdelay, depdelayminutes, depdel15, departuredelaygroups, deptimeblk, taxiout, wheelsoff, wheelson, taxii
n, crsarrtime, arrtime, arrdelay, arrdelayminutes, arrdel15, arrivaldelaygroups, arrtimeblk, cancelled, cancellationcode, diverte
d, crselapsedtime, actualelapsedtime, airtime, flights, distance, distancegroup, carrierdelay, weatherdelay, nasdelay, securityde
lay, lateaircraftdelay, firstdeptime, totaladdgtime, longestaddgtime, divairportlandings, divreacheddest, divactualelapsedtime, d
ivarrdelay, divdistance, div1airport, div1airportid, div1airportseqid, div1wheelson, div1totalgtime, div1longestgtime, div1wheels
off, div1tailnum, div2airport, div2airportid, div2airportseqid, div2wheelson, div2totalgtime, div2longestgtime, div2wheelsoff, di
v2tailnum, div3airport, div3airportid, div3airportseqid, div3wheelson, div3totalgtime, div3longestgtime, div3wheelsoff, div3tailn
um, div4airport, div4airportid, div4airportseqid, div4wheelson, div4totalgtime, div4longestgtime, div4wheelsoff, div4tailnum, div
5airport, div5airportid, div5airportseqid, div5wheelson, div5totalgtime, div5longestgtime, div5wheelsoff, div5tailnum
Remote SQL: SELECT year FROM “default”.ontime
Planning Time: 0.111 ms
Execution Time: 31441.813 ms
(7 rows)

Time: 31442.579 ms (00:31.443)

]]> By: Ibrar Ahmed https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10970698 Mon, 22 Apr 2019 17:24:00 +0000 https://www.percona.com/blog/?p=55995#comment-10970698 I have tested with this environment only
PostgreSQL 11
OS: Ubuntu and Centos

]]> By: Steven Lee https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10970689 Mon, 22 Apr 2019 00:48:28 +0000 https://www.percona.com/blog/?p=55995#comment-10970689 please google Using ClickHouse like MySQL by ProxySQL

]]> By: Steven Lee https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10970688 Mon, 22 Apr 2019 00:45:15 +0000 https://www.percona.com/blog/?p=55995#comment-10970688 Hi,
I translated it into Chinese, and want to publish on my blog, hope you can allow it.
and I have successfully compiled, installed and tested it, it is great.
and I wrote a compiling method in details, http://blog.rubypdf.com/2019/04/22/how-to-compile-and-install-clickhousedb_fdw/

]]> By: Magnus Falch https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10970687 Sun, 21 Apr 2019 19:24:33 +0000 https://www.percona.com/blog/?p=55995#comment-10970687 CREATE EXTENSION clickhousedb_fdw;
Which distros/repos will this work with currently?

]]> By: Ibrar Ahmed https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10970623 Sat, 13 Apr 2019 17:16:55 +0000 https://www.percona.com/blog/?p=55995#comment-10970623 In this current state it will fail, I am working on the translation functions. It will fail like this function does not exists in Clickhouse. You need to call a function which is available in Clickhouse, otherwise it will fail.

]]> By: faibistes https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10970621 Sat, 13 Apr 2019 08:53:15 +0000 https://www.percona.com/blog/?p=55995#comment-10970621 Does it mean that it will fail if it uses a non-translatable function in a join or aggregate, or that it will do it on the postgresql side?

]]> By: Ibrar Ahmed https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10970618 Fri, 12 Apr 2019 17:59:30 +0000 https://www.percona.com/blog/?p=55995#comment-10970618 I tried to translate operators, but not the function. If function exists in PostgreSQL and clickhouse then it will work.

]]> By: faibistes https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10970617 Fri, 12 Apr 2019 11:30:13 +0000 https://www.percona.com/blog/?p=55995#comment-10970617 What functions are supported in function pushdown? IIUC, it means that it translates postgresql functions and operators to clickhouse equivalents, if there is one. Am I right?

]]> By: Andrey https://www.percona.com/blog/postgresql-access-clickhouse-one-of-the-fastest-column-dbmss-with-clickhousedb_fdw/#comment-10970576 Fri, 05 Apr 2019 14:19:51 +0000 https://www.percona.com/blog/?p=55995#comment-10970576 it would be great if someone made a similar extension for MySQL

]]>