Apache Hive has the following SQL restrictions:
  • Column values and parameters are always nullable.
  • No support for stored procedures
  • No ROWID support
  • No support for materialized views
  • No support for synonyms
  • Primary and foreign keys are not supported.
  • Support for indexes is incomplete.
  • Join support is limited to equality joins.
  • 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".