Issue :Day :"DD"changes in (("yyyy-MM-dd") while loading to a Hive table

[Priya1211]

hi all,

I need some help on the below issue.Created a job to move data from HDFS TO HIVE TABLE.

Date format on HDFS

("yyyy-MM-dd") eg:(2012-01-04).

In my bigdata batch job ,Im using TMAP with the below transformation

TalendDate.parseDate("yyyy-MM-dd",TalendDate.formatDate("yyyy-MM-dd",DOB))

Finally after the job runs the day -'DD' in the hive table changes by a day.

HDFS: (2012-01-04).

HIVE TABLE :(2012-01-03).

I do not have any other transformation's in the job .

can someone please help.

[Anonymous]

Hi

Maybe it is caused by different timezone?

Regards

Shong

[gjeremy1617088143]

Hi Pryia, check just before sending it to Hive if your date is Ok, then As Shong say you have surely a different timezone where the hive table are.