The following restrictions are based on using Apache Hive 1.0:

  • No difference exists 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 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. 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.