Support Questions
Find answers, ask questions, and share your expertise

to load hive table to a pig iteration by hcatloader class

I am trying to load the same Hive table to a Pig Iteration and i am using the same class like whatever you had used in the video and it was giving me an error.

a = load 'flightdelays' using org.apache.hive.hcatalog.pig.HCatLoader();

Error details :

ERROR - ERROR 1070: Could not resolve org.apache.hive.hcatalog.pig.HCatLoader using imports: [, java.lang., org.apache.pig.builtin., org.apache.pig.impl.builtin.]

Can you please let me know how to reslove this?


this is for a certification question no 5 in the practice test for HDPD exam and i am using aws instance

New Contributor

Better you write the command in script file and execute it using pig -x -useHCatalog.

No Prateek....I have done that but there seems to be some should work for both the ways in the script or away on the CLI.... But it didn't

Expert Contributor

Hi Lalith,

I guess you didn't specified "-useHCatalot" in your script. Option "-useHCatalog" is not specified when starting pig.

Please refer this link for more info.