Search code examples
hiveapache-pig

Hive and Pig on top of same dataset

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?

Solution

  • 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();