clickhousedb_fdw icon indicating copy to clipboard operation
clickhousedb_fdw copied to clipboard
verified publisher icon Percona-Lab

Could clickhousedb_fdw work together with Citus?

Open yingfeng opened this issue 6 years ago • 2 comments

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 of cstore_fdw is far from good enough compared with clickhouse~

yingfeng avatar May 21 '19 10:05 yingfeng

Can you please elaborate your scenario in detail.

ibrarahmad avatar May 21 '19 22:05 ibrarahmad

Citus is a distributed postgresql solution. So my requirement is to have clickhousedb_fdw served as the column storage engine of Citus, just like cstore_fdw, in that case, the OLAP capability of Citus could be enhanced a lot. I notice that aggregation pushdown is already supported for clickhousedb_fdw, so perhaps there does not exist lots of obstacles to have it worked for Citus ?

yingfeng avatar May 22 '19 01:05 yingfeng