clickhousedb_fdw

clickhousedb_fdw copied to clipboard

If the result of the query exceeds a certain value, the process is aborted.

3

meiyifei

aggregate doesn't push down

16

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:...

harris-chiu

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...

meiyifei

why my sql cannot push down

1

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...

ethanryl

File named in documentation is not being generated when following install from source instructions

4

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...

thebf

Some JOIN syntax does not work.

1

Some JOIN syntax does not work like non-equality JOIN condition not supported in clickhousedb.

ibrarahmad

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...

kos12345

Could clickhousedb_fdw work together with Citus?

2

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...

yingfeng

clickhousedb fdw does not support the options: user and password

1

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:...

chinaworld

ibrarahmad