The following restrictions are based on using Apache Hive 0.9:

  • No support for row-level 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.