The Apache Hive server has the following restrictions:
Column values and parameters are always nullable
No ROWID support
No support for synonyms
The Hive communication protocol does not allow the driver to discover the server version
Primary and foreign keys are not supported
The length of a SQL string is limited to 2 GB
Support for indexes is incomplete
Join support is limited to equality joins.
Numeric values specified in scientific notation (for example, 1.2346E+1) are not supported in Apache Hive 0.8.
A single quote within a string literal must be escaped using a \ instead of using a single quote. Because string literals can be expressed with either single or double quotation marks, Apache's would be written as 'Apache\'s' or "Apache\'s".