Implement Hive Table Engine for Apache Hive Access in ClickHouse

Why it matters

This feature solves the problem of integrating ClickHouse with Apache Hive by allowing users to directly query Hive tables from ClickHouse. It provides value by enabling seamless interoperability between ClickHouse and Hive ecosystems without data duplication or complex ETL processes.

How to use it

To use the Hive table engine, create a table in ClickHouse with the engine set to Hive and specify the necessary connection parameters to your Hive metastore and data. For example:

CREATE TABLE hive_table_name (
    ...columns...
) ENGINE = Hive('hive_metastore_uri', 'database_name', 'table_name');

Replace hive_metastore_uri, database_name, and table_name with your Hive configuration.