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:54:11 GMT
Thanks Cheolsoo, SQOOP-456 will address my problem. In the meantime, i will
be moving ahead by truncating the time part from the export and then
processing the data because in my use-case the time is stored in another
column.

Thanks,
Anil

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

> Hi Anil,
>
> This issue is already being tracked by the following Apache JIRAs:
>
> https://issues.apache.org/jira/browse/SQOOP-451
> https://issues.apache.org/jira/browse/SQOOP-456
>
> In fact, I am currently working on adding new options via which the user
> can specify format masks for date, time, and timestamp.
>
> Thanks,
> Cheolsoo
>
>
> On Mon, Mar 12, 2012 at 2:26 PM, anil gupta <anilgupt@buffalo.edu> wrote:
>
>> From the link you had sent me in previous mail. Here is something which
>> might stop the date being converted into Timestamp:
>> "If for some reason your app is very sensitive to this change and you
>> simply must have the 9i-10g behavior, there is a connection property you
>> can set. Set mapDateToTimestamp to false and the driver will revert to
>> the default 9i-10g behavior and map DATE to Date. "  Will this help in
>> resolving this problem?
>>
>> Thanks,
>> Anil
>>
>> On Mon, Mar 12, 2012 at 2:17 PM, anil gupta <anilgupt@buffalo.edu> wrote:
>>
>>> 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
>>>
>>
>>
>>
>> --
>> Thanks & Regards,
>> Anil Gupta
>>
>
>


-- 
Thanks & Regards,
Anil Gupta

Mime
View raw message