The following restrictions apply to Apache Hive:

  • No difference between "NULL" and null values
The following restrictions apply to Hive ACID operations:
  • Hive ACID operations are supported only on servers that are configured to use them
  • Single-table operations for Updates and Deletes are supported only for tables marked as transactional
  • Hive ACID operations do not currently support Begin, Commit, or Rollback statements

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.