Guidance to implement clickhouse connector

[zeeshanabid94]

Hey guys!

We were recently looking at looker as our BI tool but as it turns out presto does not support clickhouse. Clickhouse has JDBC drivers and Presto has a extendable interface to support any JDBC driver.

I have gone through the presto developer docs. I would appreciate it if there were other sources of guidance that any one knows.

Thank you!

[ebyhr]

Hi, you can develop JDBC based connector very easily. presto-mysql or presto-postgresql in presto(this) repository would help you.
Example PR to implement JDBC based connector:

• Oracle connector: Presto Oracle connector #11540
• Teradata connector: Teradata connector #12078

Ref: #9620

[spaghettifunk]

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

[zeeshanabid94]

Hey! I already made a connector for clickhouse. Would you like to review my plugin, give feedback and eventually merge that into this repo?

[spaghettifunk]

@zeeshanabid94 of course! send me the link and i'll check it out! My team and I need to have Clickhouse working with Presto ASAP :)

[zeeshanabid94]

Great! I'll send you the link to the repo tomorrow.

[highker]

@spaghettifunk , @zeeshanabid94 could you discuss which PR you wanna proceed with? We can review once you have reached a consensus.

[highker]

Let's use #9620 to track the ticket.

[huynhphuong10284]

Great! I'll send you the link to the repo tomorrow.

Please share for this friend.