AnsweredAssumed Answered

Convert Sqoop1 script to Sqoop2

Question asked by 1004140 on Sep 15, 2016
Latest reply on Oct 25, 2016 by Rachel Silver

Hi,

We have been using SQOOP1 for some time now . We have a script which is importing data from an Oracle RDBMS.

Below is the sample SQOOP1 script ..

 

sqoop import --connect jdbc:oracle:thin:@//<DB IP >/<DB name> --query "select * from table where\$CONDITIONS" --username <username> --password <pwd> -m 1 --target-dir /tmp/hive/datasource/test1  --hive-import --hive-table test1

 

Recently , SQOOP has been upgraded to SQOOP2 . I am struggling to replicate the above SQOOP1 query in SQOOP2 .. Can you please send me the steps to follow for this ?

Outcomes