You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2019/08/12 03:03:04 UTC
[GitHub] [incubator-superset] shadowera opened a new issue #8027:
hive/impala can't show table schema
shadowera opened a new issue #8027: hive/impala can't show table schema
URL: https://github.com/apache/incubator-superset/issues/8027
I use url impala://host:port/ like this to connect to hive database , the connect is ok , and I can execute sql in the sql lab . But 'See table schema' don't seem right , it shows the databaseName not the tabels.See the screenshot for detail.
## Screenshots
See table schema should show tables but actually the databaseName.And the
![image](https://user-images.githubusercontent.com/16278112/62843654-0abe6900-bcee-11e9-8808-a5f9a8cc7499.png)
And when clicked at the item ,it comes out the error
![image](https://user-images.githubusercontent.com/16278112/62843816-75bc6f80-bcef-11e9-9b3c-f47ea33a20f3.png)
#### the console:
impala.hiveserver2:GetOperationStatus: resp=TGetOperationStatusResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None), operationState=5, sqlState=None, errorCode=0, errorMessage="org.apache.spark.sql.AnalysisException: Table or view not found: `scannetwork`.`scannetwork`; line 1 pos 14;\n'GlobalLimit 0\n+- 'LocalLimit 0\n +- 'Project [*]\n +- 'UnresolvedRelation `scannetwork`.`scannetwork`\n")
#### when I excute ' show tables', it shows the right result as follows
![image](https://user-images.githubusercontent.com/16278112/62843689-55d87c00-bcee-11e9-8bbb-49e80eed4333.png)
##Environment:
Superset 0.28.1
node.js v10.15.0
npm 6.4.1
impyla 0.15.0+2.ge4f2146
SQLAlchemy 1.2.7
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org