Pig Script in Ambari Pig View with useHCatalog tag:
a = LOAD 'batting_data' using org.apache.hive.hcatalog.pig.HCatLoader(); b = LOAD 'master_data' using org.apache.hive.hcatalog.pig.HCatLoader(); c = join a by playerid, b by playerid; dump c;
Confirmed that tables exist in default database, but get following error:
The link tells you to restart all services. We had to explicitly restart the YARN services after restarting all services in order to get YARN to work, and then the execution of the Pig script would work. Note that we explicitly added the \pigscripts directory and made sure permissions were set to 777 before we restarted.