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