Sqoop Day light Saving time mismatch

["Vikash Talanki -X (vtalanki - INFOSYS LIMITED at Cisco)" <vt...@cisco.com>]

Hi ,

I am trying to import a table that has a date field in oracle.
After Importing , I see that for some dates there is a mismatch of time by 1 hr.
I think this effect is due to day light saving.

When I import the same table using Oraoop, I am getting the correct field data.
Please let me know if there is any way around to achieve the same result in sqoop as Oraoop.

Regards
-----------------------
Vikash T
+1 (408)506 2024

Re: Sqoop Day light Saving time mismatch

[Jarek Jarcec Cecho <ja...@apache.org>]

I believe that you can set desired timezone using oracle.sessionTimeZone property, e.g.:

  sqoop import -Doracle.sessionTimeZone=America/Los_Angeles --connect ...

Is this what you're looking for?

Jarcec

On Mon, Oct 07, 2013 at 09:41:11PM +0000, Vikash Talanki -X (vtalanki - INFOSYS LIMITED at Cisco) wrote:
> Hi ,
> 
> I am trying to import a table that has a date field in oracle.
> After Importing , I see that for some dates there is a mismatch of time by 1 hr.
> I think this effect is due to day light saving.
> 
> When I import the same table using Oraoop, I am getting the correct field data.
> Please let me know if there is any way around to achieve the same result in sqoop as Oraoop.
> 
> Regards
> -----------------------
> Vikash T
> +1 (408)506 2024
>