search

ClickHouse / clickhouse-jdbc-bridge

A JDBC proxy from ClickHouse to external databases
Apache License 2.0
167 stars 60 forks source link

Does the use of clickhouse jdbc bridge support hive 2.2.0? #180

Open angshiguan opened 10 months ago

angshiguan commented 10 months ago

Does the use of clickhouse jdbc bridge support hive 2.2.0? I tested it to support hive 3.1.0. Can we support hive 2.2.0? Thank you very much!

This is the error log that occurred when connecting to hive2.2.0. In the same environment, hive3.1.0 can be accessed normally。 d766d4341ea665d4806aec6e512be0af

SharayuM commented 9 months ago

@angshiguan Can you please pass on the config that supports clickhouse jdbc bridge for Hive 3.1.0.

angshiguan commented 9 months ago

@SharayuM Thank you. It was found that adding hive-jdbc-2.2.0.jar and hive-server-2.2.0jar to the drivers can query the hive2.2.0 version. It should be that hive-jdbc-3.1.0.jar is not compatible with hive-2.2.0

SharayuM commented 9 months ago

@angshiguan What is hive-server-2.2.0jar? Can you share reference?

angshiguan commented 9 months ago

@SharayuM Because I am connecting to hive2.2.0 version, the hive-jdbc-3.1.0.jar that was previously used with version 3.1.0 is not compatible with hive2.2.0, so switching to hive-jdbc-2.20.jar will successfully connect.