question Beeline authorization failed with user name with "-" such as ambari-qa in Archives of Support Questions (Read Only)

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

ScipioTheElder — Wed, 13 Apr 2016 22:23:12 GMT

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)

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

jyadav — Wed, 13 Apr 2016 22:46:16 GMT

@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;

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

ScipioTheElder — Thu, 14 Apr 2016 01:55:14 GMT

Thanks. back tick works.