> set mapreduce.framework.name That can cause queries to fail entirely.
Similarly with hive.exec.parallel=true. > things just hang at this point. You can pull up the HiveServer logs for that (post over to user@hive lists & I will follow there). > Any recommendations that i need to make to get things to work via HS2? You need to setup a bunch of configs in hive-site.xml & needs a valid tez-site.xml for Tez (tez libs uploaded to HDFS etc) in general. For instance, I maintain recent versions of configs in my github https://github.com/t3rmin4t0r/tez-autobuild/blob/llap/tez-site.xml.frag + https://github.com/t3rmin4t0r/tez-autobuild/blob/llap/hive-site.xml.frag But after those configs, beeline + hs2 usually works fine. Cheers, Gopal PS: assuming you've loaded data via "INSERT", turning on hive.compute.query.using.stats=true should skip a Tez job for a count(*)
