Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Sqoop Day light Saving time mismatch

Copy link to this message
Re: Sqoop Day light Saving time mismatch
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?


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