AnsweredAssumed Answered

sqoop incremental import from DB2

Question asked by sesha on Dec 16, 2014
Latest reply on Dec 16, 2014 by sesha
I was trying to import incremental DB2 table data using Sqoop into Mapr Table. Timely help is highly appreciate. Below is the Sqoop command and error.

sqoop import -D mapred.job.name=abc_HBase -D mapred.job.queue.name=q1 --connect jdbc:db2://myhost:50002/DB0T --username abc --password abc --table 'schema.sampletable' --split-by ID --connection-param-file /home/db2.properties --hbase-table '/myvolume/mtable/abc' --column-family 'cf1' --hbase-row-key 'ID'  --fields-terminated-by '|' --num-mappers 2 --incremental lastmodified --check-column LST_UPDT_DT --last-value  '2014-12-15 10:28:12.551786'

Getting below error:
SQL0181 SQLCODE -181   SQLSTATE 22007, Explanation: Value in date, time, or timestamp string not valid.

Outcomes