v.22.3New Feature

Add New Hive Table Function in ClickHouse

Official CH changelog text
Add new table function hive. It can be used as follows hive('<hive metastore url>', '<hive database>', '<hive table name>', '<columns definition>', '<partition columns>') for example SELECT * FROM hive('thrift://hivetest:9083', 'test', 'demo', 'id Nullable(String), score Nullable(Int32), day Nullable(String)', 'day'). #34946 (lgbo).
Introduces a new table function hive to query Hive tables directly from ClickHouse.

Why it matters

This feature enables ClickHouse users to access and query data stored in Hive metastore tables seamlessly, improving interoperability and simplifying data integration between Hive and ClickHouse environments.

How to use it

Use the hive table function in a query by specifying the Hive metastore URL, database name, table name, columns definition, and partition columns, for example:

SELECT * FROM hive('thrift://hivetest:9083', 'test', 'demo', 'id Nullable(String), score Nullable(Int32), day Nullable(String)', 'day')

Related resources

PreviousNext