Sqoop the data from oracle to hadoop

We are trying to sqoop the data from oracle to hadoop using below given command.

sqoop import --connect "jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = = 1111))(CONNECT_DATA = (SERVER = DEDICATED)(SID = bbb)))" --username abc --password xxxx --query "select * from xx.table where \$CONDITIONS" -m 1 --target-dir /data/dev/rdv/tmpacct/ --null-string '\N' --null-non-string '\N' --hive-import --hive-table xx --hive-drop-import-delims --compression-codec org.apache.hadoop.io.compress.SnappyCodec
But after running the command we get and error like.
error :- Expected Numeric Argument.
Please Suggest what is wrong here.

Sign In or Register to comment.