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.