Hi @Ishvari Dhimmar As stated by Ervits after flattening the pig output to remove bags if there are any use the file to load into a hive table. For loading into a hive table use " load data inpath <pig out output file> into table <hive table name>". Ensure that the format of the pig output file is compatible with hive native formats. If you do so then you will achieve what you are looking for. ... View more

@Ishvari Dhimmar Please use below links for reference https://www.tutorialspoint.com/apache_oozie/index.htm https://oozie.apache.org/docs/4.2.0/DG_Hive2ActionExtension.html https://oozie.apache.org/docs/4.0.0/DG_SqoopActionExtension.html https://oozie.apache.org/docs/3.2.0-incubating/WorkflowFunctionalSpec.html ... View more

Thanks for Reply. I was thinking like this, but confused. Now its clear. Thanks again. ... View more