Support Questions
Find answers, ask questions, and share your expertise

No QUERY privilege error when connecting via Impyla, but can easily access via Hue using same user

New Contributor

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.

 

 

InkedInkedthumbnail_image002_LI.jpg

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:

apandey_2-1634802665367.png

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.

0 REPLIES 0
; ;