support for clickhouse

[cmdares]

support for clickhouse input and output.
regard!
thanks!

[hiroyuki-sato]

Hello, @cmdares

Have you ever tried embulk-input-jdbc with ClickHouse JDBC?

If that plugin doesn't work as expected, Someone needs to develop a plugin for ClickHouse JDBC.

[tac0x2a]

Hello, @cmdares and @hiroyuki-sato .

First, I tried using ClickHouse JDBC on embulk-input-jdbc, it does NOT work in current implementation.
So, I sent pull request to clickhouse-jdbc. It will work on embulk-input-jdbc for simple data types if this PR are merged.

Second, I thought ClickHouse data types need to support by embulk-input-clickhouse plugin. Then, I tried simple simple implementation and send PR .

I'm verry happy if we review this PR and improve implementation.

[hiroyuki-sato]

Hello, @cmdares
JFYI, @tac0x2a has developed embulk-input-clickhouse

Thank you @tac0x2a !

[tac0x2a]

Hi, @cmdares
Today, I fixed plugin to use just install it.

$ embulk gem install embulk-input-clickhouse

Could you try this ?

@hiroyuki-sato san
I really appreciate your support!

[cmdares]

thanks!
i found the ck jdbc client 0.1.50 release the feature:
getMetadata implementation if query was not executed yet

[sakama]

Let me close this issue.
Since embulk-input-clickhouse was released.

[cmdares]

Hi, @tac0x2a @frsyuki
thanks for the works! And there is another requirement.
embulk/embulk-output-jdbc#245
to support clickhouse output.
Because of there are many engines, especially the merge family, there are some considerations for writing speed.It is estimated that there will be more considerations.
So still want to give attention and support!
thanks! regard!