Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Reserved keywords are permitted as identifiers if you quote them as described in Supporting Quoted Identifiers in Column Names (version 0.13.0 and later, see HIVE-6013). Most of the keywords are reserved through HIVE-6617 in order to reduce the ambiguity in grammar (version 1.2.0 and later). There are two ways if the user still would like to use those reserved keywords as identifiers: (1) use quoted identifiers, (2) set hive.support.sql11.reserved.keywords=false. Note, set hive.support.sql11.reserved.keywords=false will only enable part of the reserved keywords to be used as identifier without backticks. Some of the reserved keywords, such as INTERVAL was always a reserved key word even before hive.support.sql11.reserved.keywords was introduced. Thus, the only way to use it as an identifier is through backticks.

Create/Drop/Alter Database

...