Cannot execute sqoop import control argument


#1

Hai,
I am unable to execute the sqoop import null-string and non-null-string control arguments.I am getting an error which is given in the screenshot attached below.Can you help me with this issue?


#2

Hi ,

Below command worked for me. You can revisit your syntax and correct it.

sqoop import --connect jdbc:mysql://nn01.itversity.com:3306/retail_export --username retail_dba --password itversity --table departments_test --hive-home /apps/hive/warehouse --hive-import --hive-table departments_test_123 --create-hive-table -m 1 --outdir java_files --null-string nvl --null-non-string -1

Hope it helps,

Thanks,
Dinakar

21 PM


#3

@Dinakar what is the difference between my code and the code that you have given?


#4

I noticed error at username and password and also hive directory location. Try and compare both in text editor. :slight_smile: