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

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

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?