I am using Oozie sqoop action and I want to run 100 same tables everyday hive-import from Netezza to hive. my query runs fine with Oozie workflow Sqoop action. I using hive-overwrite table every time. (1)my question is if I can specify 100 action in one workflow.xml and failed after 10 action so when I want to rerun the workflow on specific failed node how to do? (2) if I can specify 1 sqoop action in one workflow so may be i jave 100 workflow for each action which is the best approach. if we want to rerun oozie job specific failed node can you please give me sample workflow.xml looks like? I really appreciated ... View more

(1)I have created hive external table and data coming from netezza to hdfs (2) everyday we have to incremental apend to this table as well as if any data is changed to base table then what to do? I can apend as much I want but if any changed happen on base table for example few raw changed or few column changed then how I can increment works for me? everyday I have to take same table from netezza and hdfs. most probably we can apend with data_date. ... View more

I want to run sqoop query to table count records and save this result into any file locally or in hdfs but I can not. I run this query:- sqoop eval --connect hostname/db --username user --password password --query 'select count(*) from tablename' --target-dir /sandbox/test I am getting error:- Running Sqoop version: 1.4.6.2.3.0.0-2557 (Sqoop:92) 2016-03-28 11:57:55,725 WARN - [main:] ~ Setting your password on the command-line is insecure. Consider using -P instead. (BaseSqoopTool:1021) 2016-03-28 11:57:55,725 ERROR - [main:] ~ Error parsing arguments for eval: (BaseSqoopTool:303) 2016-03-28 11:57:55,725 ERROR - [main:] ~ Unrecognized argument: --target-dir (BaseSqoopTool:306) 2016-03-28 11:57:55,725 ERROR - [main:] ~ Unrecognized argument: /sandbox/test (BaseSqoopTool:306) ... View more