This page documents which parts of the SQL standard are supported by Apache Hive. The information here is not a full statement of conformance but provides users detail sufficient to generally understand Hive's SQL conformance.
This information is versioned by Hive release version, allowing a user to quickly identify features available to them.
The formal name of the current SQL standard is ISO/IEC 9075 "Database Language SQL". A revised version of the standard is released from time to time; the most recent update appearing in 2016. The 2016 version is referred to as ISO/IEC 9075:2016, or simply as SQL:2016. Hive's SQL Conformance pages reference SQL features by the Feature ID values of the SQL:2016 Standard.
| Version | Supported SQL Features |
|---|---|
| Apache Hive 2.1 | Supported SQL Features |
| Apache Hive 2.3 | Supported SQL Features |
| Apache Hive 3.1 | Supported SQL Features |
Information in these pages is not guaranteed to be accurate. Corrections can be submitted to the Apache Hive mailing list at user@hive.apache.org.