Hello,
My sqoop export is failing with a message that I am unable to solve. Below is my table structure in MySQL.It doesnt have primary key.I am using cloudera 5.4 id |department I have below data in HDFS 1,Test1 2,Test2 Initailly I used below sqoop command to export the data into the table sqoop export --table product --connect jdbc:mysql://localhost/loudacre --username training --password training --export-dir /export --update-mode allowinsert Now I modified the file in HDFS to below data 1,Test1 2,TestTest 3,Test3 and ran below sqoop command sqoop export --table product --connect jdbc:mysql://localhost/loudacre --username training --password training --export-dir /export --update-mode allowinsert --update-key id The data in the database ws updated however in logs I can see error message :- " Can't parse input data: 'null' and also it has inserted duplicate data. Can anyone help me in finding the root cause.
