Posts: 11
Registered: ‎02-21-2019

Modify datatype during sqoop import

I want to import data from oracle into hdfs. Column4 is DATE field in Oracle but i want to store it as Timestamp in hdfs. I tried both Timestamp and java.sql.Timestamp but import failed.Below is the error. Please help


sqoop import --connect *** --username *** --password ****** --query 'select column1,column2,column3,column4 from abc where $CONDITIONS' --split-by column1 --delete-target-dir --target-dir /data/encrypt/abc --compression-codec --as-parquetfile --map-column-java Column4=Timestamp


--map-column-java Column4=Timestamp

--map-column-java Column4=java.sql.Timestamp


ERROR tool.ImportTool: Import failed: No ResultSet method for Java type Timestamp


ERROR tool.ImportTool: Import failed: Cannot convert to AVRO type java.sql.Timestamp

Posts: 1,825
Kudos: 406
Solutions: 292
Registered: ‎07-31-2013

Re: Modify datatype during sqoop import

It appears that you're trying to use Sqoop's internal handling of DATE/TIMESTAMP data types, instead of using Strings which the Oracle connector converts them to.

Have you tried the option specified at


You shouldn't need to map the column types manually in this approach.
New solutions