Issue with timestamp field while using SQOOP

Asked May 23 '18 at 07:45

Active May 23 '18 at 07:45

Viewed 170 times

An extra space is added before the milliseconds while timestamp field is being ingested for eg. 05-OCT-17 03.39.02.689000000 AM is ingested as 2017-10-5 3:39:2. 689000000. Using Oracle as the source,parquet format as the format for storing the data in HDFS.

Any suggestions on how it can be avoided.

asked May 23 '18 at 07:45

Sumit Khurana

You can use --map-column-java or --map-column-hive in sqoop import – vinayak_narune May 23 '18 at 14:22
@vinayak_narune the issue is with the extra space after seconds.like 2017-10-5 3:39:2.68900000 is ingested as 2017-10-5 3:39:2.(space) 68900000 – Sumit Khurana May 23 '18 at 23:40
Can you give the sqoop statement used. – vinayak_narune May 30 '18 at 05:45

Issue with timestamp field while using SQOOP

0 Answers0