Using Oracle to ingest the data to HDFS as avrodata using SQOOP. The date/timestamp column fields are changed to long so the value is getting altered.
Example : 28-MAR-18 12.42.06.328000 PM changes to 1523401161454.
Any insights on the issue.
Asked
Active
Viewed 170 times
0
-
1Did you give a try with what is suggested in this link?https://community.hortonworks.com/questions/39141/sqoop-changing-datatype-from-datetime-to-varchar.html. – Kaushik Nayak May 04 '18 at 08:19
-
@kaushik nayak Thank you,--map-column-java worked fine for me. – Sumit Khurana May 07 '18 at 00:19