Beeline authorization failed with user name with "-" such as ambari-qa

[#1]

How to grant a user with "-" in its user name such as 'ambari-qa'?

0: jdbc:hive2://> show grant user ambari-qa in ALL;

Error: Error while compiling statement: FAILED: ParseException line 1:22 missing EOF at '-' near 'ambari' (state=42000,code=40000)

0: jdbc:hive2://> show grant user ambari\\-qa in ALL;

Error: Error while compiling statement: FAILED: ParseException line 1:22 character '\' not supported here line 1:23 character '\' not supported here (state=42000,code=40000)

[#2 · Accepted solution]

@wayne2chicagoPlease try below command. Instead of "in" it should be "on" and for username we only need to put back quote.

hive> show grant user `ambari-qa` on ALL;

[#3]

Thanks. back tick works.