I am thinking that this issue is related to class path. You need to have the HCatalog, hive jars in your PIG_CLASSPATH env variable.
From a previous post in the user list, the following this are required in the class path.
+HCatalog configuration (hive-site et al)…
On Aug 23, 2012, at 12:49 PM, Petr Babkin wrote:
I am getting the following error when trying to load the table from HCatalog into pig:
ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1070: Could not resolve org.apache.hcatalog.pig.HCatLoader using imports: [, org.apache.pig.builtin., org.apache.pig.impl.builtin.]
This is all running on HDP, so I am surprised why the resolution fails. Googling around this issue didn't bring any result.
Ontologist, Revelytix Inc.