Presto: Implement Clickhouse connector

[kale5g]

Hi there,
Are you planning to add Clickhouse connector?

[kevintop]

me too.

[kevintop]

+1

[spaghettifunk]

I opened a PR aiming to solve this problem. Happy to get feedback and help on this.

[highker]

@spaghettifunk, I did a pre-review of your PR. Please take a look. @kale5g @kevintop do you think a basic JDBC connector fits your case? If it is, @spaghettifunk, feel free to proceed.

[kevintop]

@highker @spaghettifunk Yes, it's cool.

[jondeandres]

Any update on this?

[spaghettifunk]

I'm sorry but we decided to not use Presto in our company. Unfortunately I could not work on this anymore.

[knoguchi]

Click house implemented the PostgreSQL wire protocol in July 2020. Presto should work with CH out of the box using the Postgres driver. I will test and report back.

[knoguchi]

I tried but it didn't work. I created etc/catalog/clickhouse.properties

connector.name=postgresql
connection-url=jdbc:postgresql://localhost:5433/?sslmode=disable
connection-user=myuser
connection-password=mypass

Then run the cli ./bin/presto-cli --catalog clickhouse --schema default

$ ./bin/presto-cli --catalog clickhouse --schema default
presto:default> select * from xxx;
Query 20200912_233547_00007_x3m4h failed: ERROR: ClickHouse doesn't support extended query mechanism

presto:default> show tables;
Query 20200912_233550_00008_x3m4h failed: ERROR: ClickHouse doesn't support extended query mechanism