[
https://issues.apache.org/jira/browse/HIVE-16583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ayush Saxena resolved HIVE-16583.
---------------------------------
Fix Version/s: Not Applicable
Resolution: Not A Problem
reach out to user ml if you need any help, AFAIK the use case works in hive code
> Select query fails with some exception error
> --------------------------------------------
>
> Key: HIVE-16583
> URL: https://issues.apache.org/jira/browse/HIVE-16583
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Reporter: Atul
> Priority: Critical
> Fix For: Not Applicable
>
>
> After loading the ORC file to Hive table, My select * query gets aborted with
> below error:
> 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='f\xfa\xf32\xd1KB\xbb\xb9\t\xe8\x1c\xd1\x01\xa5\xf2',
> guid=')\x17\r4\x7f D\xcf\xa0Z\xff\x8a70\xaa\x93')), orientation=4,
> maxRows=100): TFetchResultsResp(status=TStatus(errorCode=0,
> errorMessage='java.io.IOException:
> org.apache.hadoop.hive.ql.metadata.HiveException:
> java.lang.ClassCastException', sqlState=None,
> infoMessages=['*org.apache.hive.service.cli.HiveSQLException:java.io.IOException:
> org.apache.hadoop.hive.ql.metadata.HiveException:
> java.lang.ClassCastException:25:24',
> 'org.apache.hive.service.cli.operation.SQLOperation:getNextRowSet:SQLOperation.java:352',
>
> 'org.apache.hive.service.cli.operation.OperationManager:getOperationNextRowSet:OperationManager.java:221',
>
> 'org.apache.hive.service.cli.session.HiveSessionImpl:fetchResults:HiveSessionImpl.java:707',
> 'sun.reflect.GeneratedMethodAccessor45:invoke::-1',
> 'sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43',
> 'java.lang.reflect.Method:invoke:Method.java:606',
> '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:415',
> 'org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1692',
>
> 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59',
> 'com.sun.proxy.$Proxy45:fetchResults::-1',
> 'org.apache.hive.service.cli.CLIService:fetchResults:CLIService.java:454',
> 'org.apache.hive.service.cli.thrift.ThriftCLIService:FetchResults:ThriftCLIService.java:672',
>
> '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:692',
>
> 'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:285',
>
> 'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1145',
>
> 'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:615',
> 'java.lang.Thread:run:Thread.java:745',
> '*java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException:
> java.lang.ClassCastException:27:2',
> 'org.apache.hadoop.hive.ql.exec.FetchTask:fetch:FetchTask.java:154',
> 'org.apache.hadoop.hive.ql.Driver:getResults:Driver.java:1720',
> 'org.apache.hive.service.cli.operation.SQLOperation:getNextRowSet:SQLOperation.java:347',
>
> '*org.apache.hadoop.hive.ql.metadata.HiveException:java.lang.ClassCastException:34:7',
>
> 'org.apache.hadoop.hive.ql.exec.ListSinkOperator:process:ListSinkOperator.java:93',
> 'org.apache.hadoop.hive.ql.exec.Operator:forward:Operator.java:838',
> 'org.apache.hadoop.hive.ql.exec.SelectOperator:process:SelectOperator.java:88',
> 'org.apache.hadoop.hive.ql.exec.Operator:forward:Operator.java:838',
> 'org.apache.hadoop.hive.ql.exec.TableScanOperator:process:TableScanOperator.java:97',
>
> 'org.apache.hadoop.hive.ql.exec.FetchOperator:pushRow:FetchOperator.java:425',
>
> 'org.apache.hadoop.hive.ql.exec.FetchOperator:pushRow:FetchOperator.java:417',
> 'org.apache.hadoop.hive.ql.exec.FetchTask:fetch:FetchTask.java:140',
> '*java.lang.ClassCastException:null:0:-1'], statusCode=3), results=None,
> hasMoreRows=None)
> From UNIX I am getting below error:
> Failed with exception
> java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException:
> java.lang.ClassCastException:
> org.apache.hadoop.hive.serde2.io.HiveVarcharWritable cannot be cast to
> org.apache.hadoop.io.Text
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
