Support Questions

Find answers, ask questions, and share your expertise

QueryServerException: Bad status for request TExecuteStatementReq

avatar
New Contributor

HI guy,

 

Recently i have deploy one cloudera environment with kerberos enabled and sentry has been configured. A hue user with all priviledge role given was able to import data from csv. However, when i open the new table it show the following error. Somehow i still able to perform data query in hive editor. 

 

```

[02/May/2019 08:30:10 -0700] views ERROR Describe table error
Traceback (most recent call last):
File "/opt/cloudera/parcels/CDH-6.1.1-1.cdh6.1.1.p0.875250/lib/hue/apps/metastore/src/metastore/views.py", line 285, in describe_table
table = db.get_table(database, table)
File "/opt/cloudera/parcels/CDH-6.1.1-1.cdh6.1.1.p0.875250/lib/hue/apps/beeswax/src/beeswax/server/dbms.py", line 232, in get_table
raise e
QueryServerException: Bad status for request TExecuteStatementReq(confOverlay={'QUERY_TIMEOUT_S': '300'}, sessionHandle=TSessionHandle(sessionId=THandleIdentifier(secret='\xc9\x0b\xbd\xd4\xad\xd4C1\x9c\xb1\x88\xea\xa6\x03\xb9\xec', guid='\xe9\xca\xaf\xfcLwG\x00\x89\xddw\x8d\xd2`\xe3e')), runAsync=False, statement='DESCRIBE `data`.`june_2018`'):
TExecuteStatementResp(status=TStatus(errorCode=None, errorMessage="AuthorizationException: User 'someone' does not have privileges to access: default.ipay\n", sqlState='HY000', infoMessages=None, statusCode=3), operationHandle=None)
[02/May/2019 08:30:10 -0700] exceptions_renderable ERROR Potential detail: AuthorizationException: User 'hui.min.ang' does not have privileges to access: default.ipay

[02/May/2019 08:30:10 -0700] exceptions_renderable ERROR Potential trace: [('/opt/cloudera/parcels/CDH-6.1.1-1.cdh6.1.1.p0.875250/lib/hue/apps/metastore/src/metastore/views.py', 285, 'describe_table', 'table = db.get_table(database, table)'), ('/opt/cloudera/parcels/CDH-6.1.1-1.cdh6.1.1.p0.875250/lib/hue/apps/beeswax/src/beeswax/server/dbms.py', 232, 'get_table', 'raise e')]
[02/May/2019 08:30:10 -0700] middleware INFO Processing exception: DB Error: Traceback (most recent call last):
File "/opt/cloudera/parcels/CDH-6.1.1-1.cdh6.1.1.p0.875250/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/core/handlers/base.py", line 185, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/opt/cloudera/parcels/CDH-6.1.1-1.cdh6.1.1.p0.875250/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/utils/decorators.py", line 185, in inner
return func(*args, **kwargs)
File "/opt/cloudera/parcels/CDH-6.1.1-1.cdh6.1.1.p0.875250/lib/hue/apps/metastore/src/metastore/views.py", line 288, in describe_table
raise PopupException(_("DB Error"), detail=e.message if hasattr(e, 'message') and e.message else e)
PopupException: DB Error

```

 

Would this be the hue/sentry database configuration issue? 

1 REPLY 1

avatar
Rising Star

Hello Torow

 

Looking at the exception [1] it looks like an sentry hive issue , to confirm the same can you please run the query in beeline with same user "hui.min.ang" and same query and share the error you observe,

 

Could you please confirm what do you mean by "when i open the new table " do you mean creating a new table ? 

 

[1]

exceptions_renderable ERROR Potential detail: AuthorizationException: User 'hui.min.ang' does not have privileges to access: default.ipay

 

Regards

Manpreet Singh