Newbie questions - superset + hive

[Tom Ron]

Hi everyone,

We are also in the process of evaluating superset and I faced some issues which I'm not sure if it is a configuration \ connection issue or miss usage. 

I connected my superset instance (AWS EC2 m4.large) to Hive table which is in an EMR cluster.

The connection works so-so but there is few things I would like to understand better.

1. I have the following query which works fine with hive (from HUE UI)

SELECT userId, count(*)

FROM myTable

group by userId

limit 10

And I get the following error in the SQL lab tab and also in the general UI (I don't know how it is named)

TFetchResultsResp(status=TStatus(errorCode=0, errorMessage='Expected states: [FINISHED], but found ERROR', sqlState=None, infoMessages=['*org.apache.hive.service.cli.HiveSQLException:Expected states: [FINISHED], but found ERROR:26:25', 'org.apache.hive.service.cli.operation.Operation:assertState:Operation.java:202', 'org.apache.hive.service.cli.operation.SQLOperation:getNextRowSet:SQLOperation.java:430', 'org.apache.hive.service.cli.operation.OperationManager:getOperationNextRowSet:OperationManager.java:298', 'org.apache.hive.service.cli.session.HiveSessionImpl:fetchResults:HiveSessionImpl.java:791', 'sun.reflect.GeneratedMethodAccessor26:invoke::-1', 'sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43', 'java.lang.reflect.Method:invoke:Method.java:498', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:78', 'org.apache.hive.service.cli.session.HiveSessionProxy:access$000:HiveSessionProxy.java:36', 'org.apache.hive.service.cli.session.HiveSessionProxy$1:run:HiveSessionProxy.java:63', 'java.security.AccessController:doPrivileged:AccessController.java:-2', 'javax.security.auth.Subject:doAs:Subject.java:422', 'org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1698', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59', 'com.sun.proxy.$Proxy33:fetchResults::-1', 'org.apache.hive.service.cli.CLIService:fetchResults:CLIService.java:504', 'org.apache.hive.service.cli.thrift.ThriftCLIService:FetchResults:ThriftCLIService.java:690', 'org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults:getResult:TCLIService.java:1717', 'org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults:getResult:TCLIService.java:1702', 'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39', 'org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39', 'org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56', 'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:286', 'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1142', 'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:617', 'java.lang.Thread:run:Thread.java:745'], statusCode=3), results=None, hasMoreRows=None)

Querying for something like the query below works fine - 

SELECT userId

FROM myTable

limit 10

2. I have struct fields and I configured it to be struct type. How can I query the specific field (e.g SELECT myStruct.structField from ...) from the general UI?

Thank you in advance!