ClickHouse DB support

[smagellan]

Read me

Read this first before creating an issue:

• do not use this issue tracker to ask questions, instead use one of these channels. Questions will likely be closed without notice.
• you shall create a feature request only when it is general purpose enough.
• make sure that the feature is not already

Describe the feature

ClickHouse native(binary) driver

Use cases

ClickHouse is a pretty popular analytical db, so driver should be useful

Contribution

I am OK to implement that. In fact, I managed to run tck without errors without transaction test(s) since transactions are not supported by DB at the moment. Need to implement encoding of remaining types though

[vietj]

@smagellan I'm curious to know how is click house implemented ?

[smagellan]

I don't know about ClickHouse internals a lot. In general - it is columnar-oriented analytical db: https://github.com/ClickHouse/ClickHouse/. Most SELECT's are extremely fast.

P.S. driver dev branch is here: https://github.com/smagellan/vertx-sql-client/tree/feature/clickhouse-native-client

[vietj]

it seems like a lot of work, can you point out the protocol documentation you used to implement this ?

[smagellan]

Protocol is described here: https://clickhouse.tech/docs/en/interfaces/tcp/. In short: I played with console client, wireshark, https://github.com/ClickHouse/ClickHouse/tree/master/src/Client and https://github.com/mymarilyn/clickhouse-driver

[smagellan]

Hope I will create PR(into ClickHouse repo) with protocol documentation later

[vietj]

ok, would you support this contribution then in the SQL client ?

[smagellan]

Yes, I would

[vietj]

can you ping me privately ?

[smagellan]

Sure, sent you an e-mail

[tsegismont]

Hi @smagellan , I've postponed this to 4.3.0.

It would be great to land this in the next minor version. Can you confirm you can do it?

[smagellan]

Hello @tsegismont. Sure. Although I can't do that alone (Where is a merge button anyway?).

[UbiquitousBear]

@vietj / @smagellan is there any traction on this? Were you able to get it reviewed? I see loads of conflicts now...