[
https://issues.apache.org/jira/browse/HIVE-9005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14492321#comment-14492321
]
Sunil Kumar commented on HIVE-9005:
-----------------------------------
Hi,
we are getting below error on HIve 1.0.0. for log running query through JDBC
client. While Same query get executed successfully from the beeline. Can please
let me know the reason??
2015-04-13 11:32:41,622 INFO [HiveServer2-Background-Pool: Thread-42]:
ql.Driver (SessionState.java:printInfo(824)) - MapReduce Jobs Launched:
2015-04-13 11:32:41,622 INFO [HiveServer2-Background-Pool: Thread-42]:
ql.Driver (SessionState.java:printInfo(824)) - Stage-Stage-1: Map: 100 Reduce:
1 Cumulative CPU: 288.74 sec HDFS Read: 162865697 HDFS Write: 127 SUCCESS
2015-04-13 11:32:41,622 INFO [HiveServer2-Background-Pool: Thread-42]:
ql.Driver (SessionState.java:printInfo(824)) - Stage-Stage-4: Map: 100 Reduce:
1 Cumulative CPU: 291.33 sec HDFS Read: 162865697 HDFS Write: 127 SUCCESS
2015-04-13 11:32:41,623 INFO [HiveServer2-Background-Pool: Thread-42]:
ql.Driver (SessionState.java:printInfo(824)) - Stage-Stage-7: Map: 100 Reduce:
1 Cumulative CPU: 290.74 sec HDFS Read: 162865697 HDFS Write: 127 SUCCESS
2015-04-13 11:32:41,623 INFO [HiveServer2-Background-Pool: Thread-42]:
ql.Driver (SessionState.java:printInfo(824)) - Stage-Stage-9: Map: 100 Reduce:
1 Cumulative CPU: 294.8 sec HDFS Read: 162865697 HDFS Write: 127 SUCCESS
2015-04-13 11:32:41,623 INFO [HiveServer2-Background-Pool: Thread-42]:
ql.Driver (SessionState.java:printInfo(824)) - Stage-Stage-10: Map: 100
Reduce: 1 Cumulative CPU: 71.42 sec HDFS Read: 37431861 HDFS Write: 0 FAIL
2015-04-13 11:32:41,623 INFO [HiveServer2-Background-Pool: Thread-42]:
ql.Driver (SessionState.java:printInfo(824)) - Total MapReduce CPU Time Spent:
20 minutes 37 seconds 30 msec
2015-04-13 11:32:41,623 INFO [HiveServer2-Background-Pool: Thread-42]:
log.PerfLogger (PerfLogger.java:PerfLogBegin(108)) - <PERFLOG
method=releaseLocks from=org.apache.hadoop.hive.ql.Driver>
2015-04-13 11:32:41,623 INFO [HiveServer2-Background-Pool: Thread-42]:
log.PerfLogger (PerfLogger.java:PerfLogEnd(135)) - </PERFLOG
method=releaseLocks start=1428904961623 end=1428904961623 duration=0
from=org.apache.hadoop.hive.ql.Driver>
2015-04-13 11:32:41,657 ERROR [HiveServer2-Background-Pool: Thread-42]:
operation.Operation (SQLOperation.java:run(199)) - Error running hive query:
org.apache.hive.service.cli.HiveSQLException: Illegal Operation state
transition from CLOSED to ERROR
at
org.apache.hive.service.cli.OperationState.validateTransition(OperationState.java:91)
at
org.apache.hive.service.cli.OperationState.validateTransition(OperationState.java:97)
at
org.apache.hive.service.cli.operation.Operation.setState(Operation.java:125)
at
org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:157)
at
org.apache.hive.service.cli.operation.SQLOperation.access$100(SQLOperation.java:69)
at
org.apache.hive.service.cli.operation.SQLOperation$1$1.run(SQLOperation.java:196)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
at
org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:536)
at
org.apache.hive.service.cli.operation.SQLOperation$1.run(SQLOperation.java:208)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
> HiveSever2 error with "Illegal Operation state transition from CLOSED to
> ERROR"
> -------------------------------------------------------------------------------
>
> Key: HIVE-9005
> URL: https://issues.apache.org/jira/browse/HIVE-9005
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.13.1
> Reporter: Binglin Chang
> Attachments: HIVE-9005.1.patch
>
>
> {noformat}
> 2014-12-02 11:25:40,855 WARN [HiveServer2-Background-Pool: Thread-17]:
> ql.Driver (DriverContext.java:shutdown(137)) - Shutting down task :
> Stage-1:MAPRED
> 2014-12-02 11:25:41,898 INFO [HiveServer2-Background-Pool: Thread-30]:
> exec.Task (SessionState.java:printInfo(536)) - Hadoop job information for
> Stage-1: number of mappers: 0; number of reducers: 0
> 2014-12-02 11:25:41,942 WARN [HiveServer2-Background-Pool: Thread-30]:
> mapreduce.Counters (AbstractCounters.java:getGroup(234)) - Group
> org.apache.hadoop.mapred.Task$Counter is deprecated. Use
> org.apache.hadoop.mapreduce.TaskCounter instead
> 2014-12-02 11:25:41,942 INFO [HiveServer2-Background-Pool: Thread-30]:
> exec.Task (SessionState.java:printInfo(536)) - 2014-12-02 11:25:41,939
> Stage-1 map = 0%, reduce = 0%
> 2014-12-02 11:25:41,945 WARN [HiveServer2-Background-Pool: Thread-30]:
> mapreduce.Counters (AbstractCounters.java:getGroup(234)) - Group
> org.apache.hadoop.mapred.Task$Counter is deprecated. Use
> org.apache.hadoop.mapreduce.TaskCounter instead
> 2014-12-02 11:25:41,952 ERROR [HiveServer2-Background-Pool: Thread-30]:
> exec.Task (SessionState.java:printError(545)) - Ended Job =
> job_1413717733669_207982 with errors
> 2014-12-02 11:25:41,954 ERROR [Thread-39]: exec.Task
> (SessionState.java:printError(545)) - Error during job, obtaining debugging
> information...
> 2014-12-02 11:25:41,957 ERROR [HiveServer2-Background-Pool: Thread-30]:
> ql.Driver (SessionState.java:printError(545)) - FAILED: Operation cancelled
> 2014-12-02 11:25:41,957 INFO [HiveServer2-Background-Pool: Thread-30]:
> ql.Driver (SessionState.java:printInfo(536)) - MapReduce Jobs Launched:
> 2014-12-02 11:25:41,960 WARN [HiveServer2-Background-Pool: Thread-30]:
> mapreduce.Counters (AbstractCounters.java:getGroup(234)) - Group
> FileSystemCounters is deprecated. Use
> org.apache.hadoop.mapreduce.FileSystemCounter instead
> 2014-12-02 11:25:41,961 INFO [HiveServer2-Background-Pool: Thread-30]:
> ql.Driver (SessionState.java:printInfo(536)) - Stage-Stage-1: HDFS Read: 0
> HDFS Write: 0 FAIL
> 2014-12-02 11:25:41,961 INFO [HiveServer2-Background-Pool: Thread-30]:
> ql.Driver (SessionState.java:printInfo(536)) - Total MapReduce CPU Time
> Spent: 0 msec
> 2014-12-02 11:25:41,965 ERROR [HiveServer2-Background-Pool: Thread-30]:
> operation.Operation (SQLOperation.java:run(205)) - Error running hive query:
> org.apache.hive.service.cli.HiveSQLException: Illegal Operation state
> transition from CLOSED to ERROR
> at
> org.apache.hive.service.cli.OperationState.validateTransition(OperationState.java:91)
> at
> org.apache.hive.service.cli.OperationState.validateTransition(OperationState.java:97)
> at
> org.apache.hive.service.cli.operation.Operation.setState(Operation.java:116)
> at
> org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:161)
> at
> org.apache.hive.service.cli.operation.SQLOperation.access$000(SQLOperation.java:71)
> at
> org.apache.hive.service.cli.operation.SQLOperation$1$1.run(SQLOperation.java:202)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:396)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1589)
> at
> org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:504)
> at
> org.apache.hive.service.cli.operation.SQLOperation$1.run(SQLOperation.java:215)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> at java.util.concurrent.FutureTask.run(FutureTask.java:138)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
