Re: Sqoop export date error

2015-08-06 Thread Laurent H
java.lang.IllegalArgumentException: Timestamp format must be -mm-dd hh:mm:ss : check date format in your data (there can be a difference between timestamp in hive and in your DB) -- Laurent HATIER - Consultant Big Data & Business Intelligence chez CapGemini fr.linkedin.com/pub/laurent-hatier/

Sqoop export date error

2015-07-27 Thread Kumar Jayapal
Hi , I am trying to export data from hdfs to oracle Its getting error out at date column. sqoop export -Dmapred.child.java.opts="-Djava.security.egd=file:/dev/../dev/urandom" --connect "jdbc:oracle:thin:@lorsastest.kjp.com:1521/testus" --username usertest -P --table "TEST_BI.DATE_DIMENSION" --e