https://community.cloudera.com/t5/Support-Questions/Hive-queries-taking-LONG-time-to-start/m-p/155053#M117492 <P>Try running it in the debug mode and then provide the o/p here. For hivecli you could do as below:</P><PRE>hive --hiveconf hive.root.logger=DEBUG,console</PRE><P>Once done , re-run the query and see where it fails. That should give you better insight on the failure here</P> Tue, 14 Mar 2017 01:19:15 GMT skurup 2017-03-14T01:19:15Z