https://community.cloudera.com/t5/Support-Questions/HiveContext-unable-to-connect-to-exisiting-Metastore-using/m-p/226435#M188295 <P>@Jasmin,</P><P>from the metastore log, what I could find is this line which seems to be of interest: "[org.apache.hadoop.hive.common.JvmPauseMonitor$Monitor@7688c6c2]: common.JvmPauseMonitor (JvmPauseMonitor.java:run(193)) - Detected pause in JVM or host machine (eg GC): pause of approximately 8978ms"</P><P>this means that there was memory issue in Java heap for hiveserver and it paused GC due to that. Which means probably query itself got hanged. Also following this, I only see query being in progress but not completed (from the log shared). </P><P>So, it would be a good idea to check the Java heap memory and other relavant parameters.</P><PRE>-XX:NewRatio= ? -XX:MaxHeapFreeRatio= ? -XX:MinHeapFreeRatio= ? </PRE> Tue, 24 Oct 2017 12:25:48 GMT narendrakumar 2017-10-24T12:25:48Z