in Sqoop oozie Action hive-site.xml what location we have to put and In workflow.xml where I need to specify?

[#1 · Accepted solution]

@mike pal please view my example https://github.com/dbist/oozie/tree/master/apps/hcatalog

[#2]

what is purpose of sample.pig script in above link

set hcat.bin /usr/bin/hcat;

sql show tables;

[#3]

The purpose is to demonstrate pig hcatalog functionality. You can execute queries against hcatalog managed Hive tables from Pig. If you don't want to work with same table from Hive or Pig, it is not necessary.

[#4]

Hi @mike pal, have you resolved this? As Artem suggested you can put it in your workflow lib directory. You can also put it in Oozie Hive share lib directory, or in your home directory in hdfs and declare its location using <job-xml> tag in your workflow.