Limitations on Apache Hive Functionality

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.