After some research, decided to try Map Reduce as default instead of Tez. Hive started. VS components did not.
Troubleshot some more. Had to set it down to get other work done.
So then I had to prepare for the demo on Polybase and sure enough my Hadoop sandbox stopped working the day prior to the demo.
So actually read my own blog and blog to redo the steps to get Hyper-V Sandbox working. While there I poked around at some of the settings. Actually, all the Hive settings, Pig, Tez and Yarn.
Decided to change default back to Tez.
Also noticed the /user/yarn/ folder was missing in HDFS, added that.
Looking at the resources, HDFS was filling up throwing an alert, for no reason. Looking at the jobs, there were 171 pending jobs in the queue.
It was in the Yarn settings something didn't look correct. Did some research online, although the default setting for yarn.acl.enable = false, didn't seem correct as that schedules the jobs in the queue for Yarn. Restarted the services, no luck.
Ran Visual Studio 2015 Hadoop HDFS, Pigg and Hive scripts, all ran.
This was a tough one. Hadoop has SO many configuration settings. And everything is interconnected. And I wasn't supposed to be solving this issue at the moment.
Back in business.
And there you have it~!