Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Incomplete
-
Affects Version/s: 4.3.0
-
Fix Version/s: None
-
Component/s: con.hive
-
Labels:None
Description
When using the Table Creation wizard we select "Manually" and create the table specs. When saving the table we get an error message "DB Error AnalysisException: Could not resolve path: 'default.test5'"
[19/Feb/2019 14:19:59 +0100] exceptions_renderable ERROR Potential detail: AnalysisException: Could not resolve path: 'default.test5' [19/Feb/2019 14:19:59 +0100] views ERROR Describe table errorTraceback (most recent call last): File "/opt/cloudera/parcels/CDH-6.1.0-1.cdh6.1.0.p0.770702/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.0-1.cdh6.1.0.p0.770702/lib/hue/apps/beeswax/src/beeswax/server/dbms.py", line 232, in get_table raise eQueryServerException: Bad status for request TExecuteStatementReq(confOverlay={'QUERY_TIMEOUT_S': '300'}, sessionHandle=TSessionHandle(sessionId=THandleIdentifier(secret='|\xfeG\xc8\xdfZH"\x9b\x11\x9f\xa4\xd9\x88b;', guid='&\xa8\xfbX\xcc\xa0E\xed\xb0\xca\xe3\xfc\x00m~\x81')), runAsync=False, statement='DESCRIBE FORMATTED `default`.`test5`'):TExecuteStatementResp(status=TStatus(errorCode=None, errorMessage="AnalysisException: Could not resolve path: 'default.test5'\n", sqlState='HY000', infoMessages=None, statusCode=3), operationHandle=None) [19/Feb/2019 14:19:59 +0100] dbms DEBUG Seems like default.test5 could be a Kudu table [19/Feb/2019 14:19:59 +0100] thrift_util DEBUG Thrift call: <class 'ImpalaService.ImpalaHiveServer2Service.Client'>.ExecuteStatement(args=(TExecuteStatementReq(confOverlay={'QUERY_TIMEOUT_S': '300'}, sessionHandle=TSessionHandle(sessionId=THandleIdentifier(secret=LOG-REDACTED guid=ed45a0cc58fba826:817e6d00fce3cab0)), runAsync=False, statement='DESCRIBE FORMATTED `default`.`test5`'),), kwargs={}) returned in 3ms: TExecuteStatementResp(status=TStatus(errorCode=None, errorMessage="AnalysisException: Could not resolve path: 'default.test5'\n", sqlState='HY000', infoMessages=None, statusCode=3), operationHandle=None) [19/Feb/2019 14:19:59 +0100] thrift_util DEBUG Thrift call: <class 'ImpalaService.ImpalaHiveServer2Service.Client'>.ExecuteStatement(args=(TExecuteStatementReq(confOverlay={'QUERY_TIMEOUT_S': '300'}, sessionHandle=TSessionHandle(sessionId=THandleIdentifier(secret=LOG-REDACTED guid=ed45a0cc58fba826:817e6d00fce3cab0)), runAsync=False, statement='DESCRIBE FORMATTED `default`.`test5`'),), kwargs={})
It seems as if Hue tries to run a DESCRIBE FORMATTED against Impala immediately after creating the table but it didn't actually do a metadata refresh.
When we do the refresh manually everything works as expected but the error message is very confusing for users.
We encounter this on CDH 6.1.