sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anil gupta <anilg...@buffalo.edu>
Subject Re: Sqoop modifies the DATE format in the exported data
Date Mon, 12 Mar 2012 21:17:43 GMT
Hi Cheolsoo,

Thanks for the inputs. AFAIK, SQL Developer also uses JDBC but its dumping
the data in the same format as its in DB. So, i am wondering why Sqoop is
unable to dump the data similar to SQL Developer? I am using SQL Developer
3.1.07.

Thanks,
Anil Gupta

On Mon, Mar 12, 2012 at 2:08 PM, Cheolsoo Park <cheolsoo@cloudera.com>wrote:

> Hi Anil,
>
> Some of the Oracle JDBC drivers (version < 9.2 && > 11.1) auto-converts
> date to timestamp:
>
> http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#08_01
>
> Since Sqoop uses the JDBC driver to import data from the Oracle db, dates
> in output files are in the form of timestamp.
>
> Thanks,
> Cheolsoo
>
>
> 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
>>
>
>


-- 
Thanks & Regards,
Anil Gupta

Mime
View raw message