Major Description
When cancel the query is running on spark, the SparkJobMonitor can not return, therefore the locks hold by the query can not be released. When enable debug in log, you will see many log info as following:
2018-02-09 08:27:09,613 INFO org.apache.hadoop.hive.ql.exec.spark.status.SparkJobMonitor: [HiveServer2-Background-Pool: Thread-80]: state = CANCELLED 2018-02-09 08:27:10,613 INFO org.apache.hadoop.hive.ql.exec.spark.status.SparkJobMonitor: [HiveServer2-Background-Pool: Thread-80]: state = CANCELLED