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 ?