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

Discovering Schemas

The CData ADO.NET Provider for Apache Hive dynamically obtains the Apache 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, Apache Hive scans only the relevant partition. Otherwise, Apache 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.