开启Debug日志:
beeline 提交SQL
2019-12-30 13:22:46,110 DEBUG org.apache.hadoop.hive.ql.Driver: [HiveServer2-Handler-Pool: Thread-293939]: Acquire a monitor for compiling query
2019-12-30 13:23:26,017 INFO org.apache.hadoop.hive.ql.log.PerfLogger: [HiveServer2-Handler-Pool: Thread-293939]: <PERFLOG method=compile from=org.apache.hadoop.hive.ql.Driver>
时间花在获取monitor lock
jstack -l pid(Hiveserver2实例)
"HiveServer2-Handler-Pool: Thread-303969" prio=10 tid=0x00007f620a623800 nid=0x209c waiting on condition [0x00007f61d6ca4000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x000000040a841248> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)
at java.util.concurrent.locks.LockSupport.park(LockSupport.java:186)
at java.util.concurrent.locks.AbstractQueuedSynchronizer.parkAndCheckInterrupt(AbstractQueuedSynchronizer.java:834)
at java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireQueued(AbstractQueuedSynchronizer.java:867)
at java.util.concurrent.locks.AbstractQueuedSynchronizer.acquire(AbstractQueuedSynchronizer.java:1197)
at java.util.concurrent.locks.ReentrantLock$NonfairSync.lock(ReentrantLock.java:214)
at java.util.concurrent.locks.ReentrantLock.lock(ReentrantLock.java:290)
at org.apache.hadoop.hive.ql.Driver.tryAcquireCompileLock(Driver.java:1344)
at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1284)
at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:1277)
at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:134)
at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:206)
at org.apache.hive.service.cli.operation.Operation.run(Operation.java:327)
at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:424)
at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:401)
a
Beeline 提交SQL Hang问题定位
最新推荐文章于 2023-01-15 09:23:02 发布