Hive Compatible Data Source Limitations

Apache Hive is a data warehouse infrastructure that lets you query and analyze large data sets stored in Apache Hadoop files. Hive uses a simple SQL-like query language called QL to query the data. TDV supports several Hive-based database solutions. For a list and associated version numbers, see the TDV Installation and Upgrade Guide. For information about how to enable security on your Hive data sources see the TDV Administration Guide.

Because queries are distributed across several Hive nodes, queries that process only a small amount of data might finish slower than expected.

Back referencing table aliases in the ORDER BY clause is not supported by Hive. In order to achieve this, you must include the columns used by the ORDER BY clause in the SELECT clause with table alias.

Top