Member since
10-31-2016
1
Post
1
Kudos Received
0
Solutions
10-31-2016
07:25 AM
1 Kudo
I am getting the error when running the query 'Select * from table'
Fetching results ran into the following error(s):
Bad status for request TFetchResultsReq(fetchType=0, operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret='\x85\x8b5\xa3\xd5\xe3N\xf6\x9a8t>5s\x8e\xd8', guid='v"\xf5\xdd\xf6>J\xc7\x98\x16K\xeau\x81C+')), orientation=4, maxRows=100): TFetchResultsResp(status=TStatus(errorCode=0, errorMessage='Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=7622f5dd-f63e-4ac7-9816-4bea7581432b]', sqlState=None, infoMessages=['*org.apache.hive.service.cli.HiveSQLException:Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=7622f5dd-f63e-4ac7-9816-4bea7581432b]:12:11', 'org.apache.hive.service.cli.operation.OperationManager:getOperation:OperationManager.java:170', 'org.apache.hive.service.cli.CLIService:fetchResults:CLIService.java:438', 'org.apache.hive.service.cli.thrift.ThriftCLIService:FetchResults:ThriftCLIService.java:689', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults:getResult:TCLIService.java:1553', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults:getResult:TCLIService.java:1538', 'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39', 'org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39', 'org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingProcessor:process:HadoopThriftAuthBridge.java:718', 'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:285', '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)
But able to get the result when I am running the same query from hive CLI and after invalidating running from impala also..
Environment Details:
cdh 5.7.1
hive-1.1.0
... View more
Labels:
- Labels:
-
Apache Hive
-
Cloudera Hue