question Re: in Sqoop oozie Action hive-site.xml what location we have to put and In workflow.xml where I need to specify? in Archives of Support Questions (Read Only)

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

vijaysvnit2005 — Thu, 17 Mar 2016 20:34:01 GMT

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

aervits — Thu, 17 Mar 2016 20:51:36 GMT

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

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

vamsi123 — Mon, 16 May 2016 21:56:44 GMT

what is purpose of sample.pig script in above link

set hcat.bin /usr/bin/hcat;

sql show tables;

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

aervits — Wed, 18 May 2016 08:20:46 GMT

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.

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

pminovic — Thu, 19 May 2016 07:44:33 GMT

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.