Hive and Pig on top of same dataset

Question

Lets say: I have a table associated with a hive structure. Can I create a pig schema over this table data? Will hive query and pig schema -both be workable?

Answer 1

Yes. You will need HCatalog.In Pig Shell run the below command to import the necessary jars.

pig -useHCatalog

Then load the table into a relation like this

A = LOAD 'tablename' USING org.apache.hive.hcatalog.pig.HCatLoader();