Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

how to load data to pig from hive table in hdp 3.0 ?

Highlighted

how to load data to pig from hive table in hdp 3.0 ?

Expert Contributor

Hi,

I am using hortonworks sandbox hdp 3.0 . I am trying to load pig relation from hive table using below script

pig -x tez -useHCatalog
a = load 'exam.emp' using org.apache.hive.hcatalog.pig.HCatLoader();
dump a;

When i describe relation 'a' after executing load statement it shows the schema same as hive table structure. But when i try to dump relation a no data gets load from hive table.

can anyone help me resolve this issue ?

Thank you

Don't have an account?
Coming from Hortonworks? Activate your account here