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.