skip to main content
DataDirect Connect XE Drivers : The Driver for Apache Hive : Restrictions for Apache Hive Functionality
  
Restrictions for Apache Hive Functionality
The following restrictions are based on using Apache Hive 0.9:
*No support for row-level inserts, updates, or deletes
*No difference exists between "NULL" and null values
*For HiveServer1 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 complete list of Apache Hive known issues and version-specific limitations, refer to your Apache Hive user documentation:
https://cwiki.apache.org/confluence/display/Hive/Home
Note: Apache Hive is not designed for Online Transaction Processing (OLTP) workloads and does not offer real-time queries or row-level updates. Instead, it is designed to process batch type jobs with large data sets. This means that queries such as "SELECT * FROM mytable" can return results quickly; however, other Select statements may process much slower.
Note: Apache HiveServer1 servers do not currently handle multiple concurrent connections well. Consider using a single Apache HiveServer1 server for each connection.