Escape an illegal identifier
When you need to use reserved words, special characters, or a space in a column or partition name, enclose it in backticks (`).
An identifier in SQL is a sequence of alphanumeric and underscore (_) characters enclosed in backtick characters. In Hive, these identifiers are called quoted identifiers and are case-insensitive. You can use the identifier instead of a column or table partition name.
column
in the hive-site.xml file
to enable quoted identifiers: Set the hive.support.quoted.identifiers
configuration parameter to column
in the hive-site.xml
file to enable quoted identifiers in column names. Valid values are none
and column
. For example, hive.support.quoted.identifiers =
column
.