Date issue when copying data from Phoenix to Spark

[Pavani Addanki <pa...@gmail.com>]

I am trying to insert phoenix data into spark, found that the date is
changing after inserting into spark. For ex: Date in Phoenix is showing as
2017-10-10 but when same is seen in spark it is showing as 2017-10-19.

Did anyone else face the same issue.


Thanks and Regards,

Pavani A

Re: Date issue when copying data from Phoenix to Spark

[Csaba Skrabak <cs...@hortonworks.com>]

I don't think there is a GMT+216:00 time zone.

Pavani, can you maybe tell which version of Phoenix and which version of Spark you used when observing this? What exact command you used to insert into spark?





On 18/10/17 23:51, "sergey.soldatov@gmail.com on behalf of Sergey Soldatov" <sergey.soldatov@gmail.com on behalf of sergeysoldatov@gmail.com> wrote:

>Just a guess. Date is storying as the regular timestamp in GMT. So Phoenix
>shows you the GMT time while Spark is convert GMT time to you local time
>zone.
>
>Thanks,
>Sergey
>
>On Tue, Oct 17, 2017 at 3:54 PM, Pavani Addanki <pa...@gmail.com>
>wrote:
>
>> I am trying to insert phoenix data into spark, found that the date is
>> changing after inserting into spark. For ex: Date in Phoenix is showing as
>> 2017-10-10 but when same is seen in spark it is showing as 2017-10-19.
>>
>> Did anyone else face the same issue.
>>
>>
>> Thanks and Regards,
>>
>> Pavani A
>>

Re: Date issue when copying data from Phoenix to Spark

[Sergey Soldatov <se...@gmail.com>]

Just a guess. Date is storying as the regular timestamp in GMT. So Phoenix
shows you the GMT time while Spark is convert GMT time to you local time
zone.

Thanks,
Sergey

On Tue, Oct 17, 2017 at 3:54 PM, Pavani Addanki <pa...@gmail.com>
wrote:

> I am trying to insert phoenix data into spark, found that the date is
> changing after inserting into spark. For ex: Date in Phoenix is showing as
> 2017-10-10 but when same is seen in spark it is showing as 2017-10-19.
>
> Did anyone else face the same issue.
>
>
> Thanks and Regards,
>
> Pavani A
>