clickhousedb_fdw
clickhousedb_fdw copied to clipboard
PostgreSQL's Foreign Data Wrapper For ClickHouse
I have run the test in sql/clickhousedb_fdw.sql It appears that the aggregate doesn't push down as expected EXPLAIN (VERBOSE, COSTS OFF) select count(*) from ft1; QUERY PLAN ---------------------------------------------------- Aggregate Output:...
2019.06.26 17:06:18.942407 [ 49 ] {309308e1-6710-40f5-ad68-491d1f8a3fd5} virtual DB::MergingAndConvertingBlockInputStream::~MergingAndConvertingBlockInputStream(): Waiting for threads to finish 2019.06.26 17:06:18.944886 [ 49 ] {309308e1-6710-40f5-ad68-491d1f8a3fd5} MemoryTracker: Peak memory usage (total): 109.37 MiB. 2019.06.26 17:06:18.945094 [ 49...
PostgreSQL 11 OS: Centos 7.6 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...
File named in documentation is not being generated when following install from source instructions
I've gone through and resolved all the dependencies that a fresh install is missing to be able to make and install this project. The only .so files i can find...
Some JOIN syntax does not work like non-equality JOIN condition not supported in clickhousedb.
hello. i have two questions. 1. is it possible to see datatype array(string) via clickhouse_fdw? for example table in clickhouse: create table events (id int8, field1 Array(String)); Create foreign table...
If not, do you have any suggestions on adjusting both Citus as well as clickhousedb_fdw such that clickhousedb_fdw could work within Citus just like cstore_fdw? After all, the olap capability...
clickhousedb fdw does not support the options: user and password. postgres=# CREATE SERVER clickhouse_svr FOREIGN DATA WRAPPER clickhousedb_fdw OPTIONS(dbname 'test_database', driver '/usr/local/lib/odbc/libclickhouseodbc.so', host '127.0.0.1', user 'default', password 'clickhouse'); postgres=# error:...