The adapter models Apache Hive instances as relational databases. Hive versions 0.11.0 and above are supported. The adapter leverages the HiveServer2 Thrift API, to enable bidirectional access to Apache Hive data through SQL.

Discovering Schemas

The Hive Adapter dynamically obtains the Hive schemas. Reconnect to load any changes in the metadata, such as added or removed columns or changes in data type.

Note: For best performance, use a column that is also a partition key when filtering data. When a partition key is used, Hive scans only the relevant partition. Otherwise, Hive scans all underlying files before applying the filter, which can significantly increase execution time. See HiveQL Statements to verify whether a table is partitioned.