sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cheolsoo Park <cheol...@cloudera.com>
Subject Re: Sqoop modifies the DATE format in the exported data
Date Mon, 12 Mar 2012 21:08:46 GMT
Hi Anil,

Some of the Oracle JDBC drivers (version < 9.2 && > 11.1) auto-converts
date to timestamp:

Since Sqoop uses the JDBC driver to import data from the Oracle db, dates
in output files are in the form of timestamp.


On Mon, Mar 12, 2012 at 1:57 PM, anil gupta <anilgupta84@gmail.com> wrote:

> Hi All,
> I am exporting a table from Oracle using Sqoop. I have a date column in
> Oracle table with  format as DD-MON-YY. I get the same format when i dump
> the data from Oracle SQL Developer. But, when i dump the data using Sqoop i
> get the following format YYYY-MM-DD HH:MM:SS.x.
> For the value "24-JAN-08" in DB, Sqoop will dump it as  "2008-01-24
> 00:00:00.0". Is this an expected behavior? If yes, please let me know why
> does sqoop adds the unnecessary timestamp at the end and also modifies the
> original date format?
> --
> Thanks & Regards,
> Anil Gupta

View raw message