- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
QueryServerException: Bad status for request TExecuteStatementReq
- Labels:
-
Apache Hive
-
Cloudera Hue
Created on ‎05-02-2019 08:37 AM - edited ‎09-16-2022 07:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Created ‎05-03-2019 06:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
