Member since
10-21-2021
1
Post
0
Kudos Received
0
Solutions
10-21-2021
12:58 AM
Hi, I'm facing the following error when connecting to Hive server with Kerberos authentication. Please keep in mind that I can access and query the database easily from Hue. And, I'm not the admin. I'm only trying to connect to the Hive Server to read some tables and I wont get ALL privilege. Admin tells me that I already have SELECT privilege but I cannot access at all. Error while compiling statement: FAILED: SemanticException No valid privileges User xxxxxx does not have privileges for QUERY The required privileges: Server=server1=>db=xxx->Table=xxxxx->Column=act_type->action=select; The code snippet that I use to connect are as follows: from impala.dbapi import connect
conn = connect( host="host.com",
port=10000,
kerberos_service_name="hive",
auth_mechanism="GSSAPI") However, when I specify a name of database like: from impala.dbapi import connect
conn = connect(
host="host.com",
port=10000,
database = "xxx",
kerberos_service_name="hive",
auth_mechanism="GSSAPI") I get following error: Error while compiling statement: FAILED: SemanticException No valid privileges User xxxxxx does not have privileges for SWITCHDATABASE The required privileges: Server=server1=>db=xxx->Table=*->Column=*->action=select;db=xxx->Table=*->Column=*->action=insert; Please help. Thank You.
... View more
Labels:
- Labels:
-
Apache Impala
-
Kerberos