09-22-2014 02:46 AM
I ran the below query in Hive Shell, i got the below error,
hive> SHOW ROLES;
FAILED: SemanticException The current builtin authorization in Hive is incomplete and disabled.
We are trying to provide the grant access for the user 'cloudera' for all hive tables in default database.After we need to access the tables in SAS enviroenment with user 'cloudera'.
We are using imapala.odbc.drivers in SAS linux server end.
Can you please help me out here and let me know if you need any further inforamtion.
10-03-2014 04:08 AM
bad luck, i also suffered this errors when i combine the HIVE and Sentry to work together, and i have opened DEBUG for every service, but didn't find anything.
anybody could help us ?
10-03-2014 07:53 AM
buddy, i hve got to resolve this problem now.
i am not sure we are the same problem. because my problem is i didn't grant privileges to user by beeline, perviously, i always grant privileges by HIVE, that's wrong.
10-03-2014 07:58 AM
another thing, be remember, if you adapter Kerberos, you must use principal to login beeline. l
like: !connect jdbc:hive2://localhost:10000,principal=hive@yourhost@DOMAIN
after login, you can create role, and grant privileges to group.