skip to main content
Supported SQL Functionality and Extensions : Restrictions : Other restrictions
  

Try DataDirect Drivers Now

Other restrictions

The Apache Hive server has the following restrictions:
*Column values and parameters are always nullable
*No ROWID support
*No support for synonyms
*Primary and foreign keys are not supported.
*The length of a SQL string is limited to 2 GB.
*Support for indexes is incomplete
The ACID operations have the following restrictions:
*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