Limitations on Apache Hive Functionality

Part 4: The Connect XE Drivers : The Driver for Apache Hive : Limitations on Apache Hive Functionality

The following restrictions are based on using Apache Hive 0.10.0:

No support for row-level inserts, updates, or deletes

No difference between "NULL" and null values

For HiverServer1 connections, no support for user-level authentication

For HiveServer1 connections, no support for canceling a running query

For HiveServer1 connections, no support for multiple simultaneous connections per port

For a more complete listing of Apache Hive known issues and limitations for your version of Hive, refer to the Apache Hive user documentation:

https://cwiki.apache.org/confluence/display/Hive/Home

Note: Note that Apache Hive is not designed for OLTP workloads and does not offer real-time queries or row-level updates. Instead, Hive is designed for batch type jobs over large data sets with high latency. This means that queries such as "SELECT * FROM mytable" return quickly. However, other SELECT statements are much slower.

Note: Because Apache HiveServer1 servers do not currently handle multiple connections well, consider using a single Apache HiveServer1 for each connection.