i have created hdinsight cluster on azure. i want to store pig output to the hive table using oozie job. how can i do this ? can anyone give me the example of Workflow and job file for this.
Basically, your Oozie workflow is required to have a Pig action in order to execute a pig script.
Here is a generic outline of the same :
You may refer this wiki for various use-cases of Pig via Oozie.
In the Pig script, you must use HCatStorer to save Pig output to Hive.
STORE my_pig_output INTO 'dbname.tablename' USING org.apache.hive.hcatalog.pig.HCatStorer();
Here is an example of Oozie Workflow with Pig Action. Although, this example does not cover this exact scenario that you are looking for, it will still give you a clear idea of what you will need to do in order to create the required workflow.
As always, if this answer helps you, please consider accepting it.