search

ClickHouse / ClickHouse

ClickHouse® is a real-time analytics DBMS
https://clickhouse.com
Apache License 2.0
37.57k stars 6.9k forks source link

External Dictionaries JDBC source #33240

Open UnamedRus opened 2 years ago

UnamedRus commented 2 years ago

Describe the unexpected behaviour Allow to use jdbc as source for external dictionaries.

Looks like it was prohibited for some reason many years ago.

https://github.com/ClickHouse/ClickHouse/blob/888a5532a682d8b3950a039f611968f80bad1ab5/src/Dictionaries/XDBCDictionarySource.cpp#L267

alexey-milovidov commented 2 years ago

@kitaisreal this makes sense...

alexey-milovidov commented 2 years ago

@UnamedRus First we need to put clickhouse-jdbc-bridge into the ClickHouse package using a self-contained binary or Java machine without dependencies. Otherwise, there is no much value in implementing this task.

UnamedRus commented 2 years ago

For odbc-bridge, you also need to download odbc-drivers for different databases, i don't see that big difference here compared to jdbc-bridge.

alexey-milovidov commented 2 years ago

@UnamedRus the bridge itself should be included in ClickHouse.