skip to main content
Supported SQL Functionality and Extensions for The Driver for Apache Hive : Restrictions : Other Restrictions
  
Other Restrictions
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".