Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: document case sensitivity issue in 0.13

...

Names of Users and Roles

Role names are case sensitive. In hive 0.13, however, there was a bug that caused it to have case insensitive . That is, “marketing” and “MarkEting” refer to same rolebehavior. That issue has been fixed in hive 0.14.

User names are case sensitive. This is because, unlike role names, user names are not managed within Hive.

Info
titleQuoted Identifiers in Version 0.13.0+

As of Hive 0.13.0, user and role names may optionally be surrounded by backtick characters (`) when the configuration parameter hive.support.quoted.identifiers is set to column (default value). All Unicode characters are permitted in the quoted identifiers, with double backticks (``) representing a backtick character. However when hive.support.quoted.identifiers is set to none, or in Hive 0.12.0 and earlier, only alphanumeric and underscore characters are permitted in user names and role names.

For details, see HIVE-6013 and Supporting Quoted Identifiers in Column Names.

As of Hive 0.14, user may be optionally surrounded by backtick characters (`) irrespective of the hive.support.quoted.identifiers setting.

...