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

[#1]

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.