Created 06-09-2017 02:04 AM
Hello all,
I have this below action Oozie workflow but I keep getting these error:
ERROR org.apache.sqoop.tool.BaseSqoopTool - Error parsing arguments for import:
ERROR org.apache.sqoop.tool.BaseSqoopTool - Unrecognized argument: --hive-drop-import-delimns
ERROR org.apache.sqoop.tool.BaseSqoopTool - Unrecognized argument: --hive-overwrite
ERROR org.apache.sqoop.tool.BaseSqoopTool - Unrecognized argument: --hive-table
ERROR org.apache.sqoop.tool.BaseSqoopTool - Unrecognized argument: test_tmp
ERROR org.apache.sqoop.tool.BaseSqoopTool - Unrecognized argument: --target-dir
ERROR org.apache.sqoop.tool.BaseSqoopTool - Unrecognized argument: /apps/hive/warehouse/test
ERROR org.apache.sqoop.tool.BaseSqoopTool - Unrecognized argument: -m
ERROR org.apache.sqoop.tool.BaseSqoopTool - Unrecognized argument: 1
----------------------------- Oozie Workflow ----------------------------
<action name="sqoop-node">
<sqoop xmlns="uri:oozie:sqoop-action:0.2">
<job-tracker>${jobTracker}</job-tracker>
<name-node>${nameNode}</name-node>
<prepare>
<delete path="hdfs://localhost/test-oozie/examples/output-data/sqoop"/>
<mkdir path="hdfs://localhost/test-oozie/examples/output-data"/> </prepare>
<configuration>
<property> <name>mapred.job.queue.name</name>
<value>${queueName}</value> </property> </configuration>
<arg>import</arg>
<arg>--connect</arg>
<arg>jdbc:oracle:thin:</arg>
<arg>--username</arg>
<arg>user</arg>
<arg>--password</arg>
<arg>pwd</arg>
<arg>--query</arg>
<arg>SELECT * FROM MYTASK WHERE STARTTIME BETWEEN TO_DATE('2017-06-08 14:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2017-06-08 14:10:59','YYYY-MM-DD HH24:MI:SS') AND $CONDITIONS)</arg>
<arg>--hive-import</arg>
<arg>--hive-drop-import-delimns</arg>
<arg>--hive-overwrite</arg>
<arg>--hive-table</arg>
<arg>test_tmp</arg>
<arg>--target-dir</arg>
<arg>/apps/hive/warehouse/test</arg>
<arg>-m</arg>
<arg>1</arg>
Would you please help me why I got the Unrecognized argument ?
Thank you for your help.
JT
Created 06-24-2017 05:08 PM
This looks like it could be due to a typo in one of your arguments. Your workflow contains "--hive-drop-import-delimns" (note the "n" as the second to last character), but according to the sqoop documentation, this should be "--hive-drop-import-delims". Can you try correcting that and see if your job successfully parses?
Source: https://sqoop.apache.org/docs/1.4.1-incubating/SqoopUserGuide.html#_importing_data_into_hive