Thomas Rebele created HIVE-30013:
------------------------------------

             Summary: Value HiveProject(_c0 of type java.lang.String cannot be 
converted to JSONObject
                 Key: HIVE-30013
                 URL: https://issues.apache.org/jira/browse/HIVE-30013
             Project: Hive
          Issue Type: Bug
            Reporter: Thomas Rebele


The following commands in Beeline execute without a warning:
{noformat}
SET hive.server2.logging.operation.level=VERBOSE;
explain formatted cbo select 1;{noformat}
The following script however, outputs a warning of an exception:
{noformat}
SET hive.server2.logging.operation.level=VERBOSE;
explain cbo select 1; {noformat}
The stacktrace of the exception was:
{noformat}
WARN  : Exception generating explain output: org.json.JSONException: Value 
HiveProject(_c0 of type java.lang.String cannot be converted to JSONObject
org.json.JSONException: Value HiveProject(_c0 of type java.lang.String cannot 
be converted to JSONObject
        at org.json.JSON.typeMismatch(JSON.java:112)
        at org.json.JSONObject.<init>(JSONObject.java:175)
        at org.json.JSONObject.<init>(JSONObject.java:188)
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.getJSONPlan(ExplainTask.java:299)
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.getJSONPlan(ExplainTask.java:277)
        at 
org.apache.hadoop.hive.ql.exec.ExplainTask.getExplainOutput(ExplainTask.java:1469)
        at org.apache.hadoop.hive.ql.Compiler.explainOutput(Compiler.java:461)
        at org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:124)
        at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:500)
        at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:452)
        at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:416)
        at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:410)
        at 
org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:127)
        at 
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:217)
        at 
org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:280)
        at 
org.apache.hive.service.cli.operation.Operation.run(Operation.java:292)
        at 
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:559)
        at 
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:544)
        at 
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
        at java.base/java.lang.reflect.Method.invoke(Method.java:580)
        at 
org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:79)
        at 
org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:64)
        at 
java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
        at java.base/javax.security.auth.Subject.doAs(Subject.java:525)
        at 
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1964)
        at 
org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:60)
        at jdk.proxy2/jdk.proxy2.$Proxy36.executeStatementAsync(Unknown Source)
        at 
org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:312)
        at 
org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:651)
        at 
org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1670)
        at 
org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1650)
        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:38)
        at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:38)
        at 
org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:57)
        at 
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:250)
        at 
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
        at 
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
        at java.base/java.lang.Thread.run(Thread.java:1583) {noformat}
I've tried to reproduce it with a q file test, but unfortunately the q.out file 
does not include the logs.

I've used Hive built from commit 86d8f6d3ccee4b8084b50a4bc4edfd4a798b9817.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to