phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gabriel Reid <>
Subject Re: Time change when bulk load csv to phoenix
Date Tue, 10 Feb 2015 11:13:10 GMT
Hi Thanaphol,

Could you elaborate on how you're debugging this issue? The reason I ask is
that the JDBC Timestamp class does some of its own formatting when you
query it as a string (it formats the string to a timestamp in the local

The general rules are as follows:
* the bulk loader interprets date/time/timestamp strings as being in GMT
* Phoenix stores only the long value of the date/time/timestamp internally
* JDBC date/time/timestamp values are instantiated based on the long value
when you query them

In other words, Phoenix treats everything internally as being in GMT.
However, if you run a query on a timestamp column in a non-GMT locale and
display the timestamps as strings, the string will be the local timezone
representation of the GMT timestamp -- the internal long value will be the
same, but the string representation will be different than the file that
you imported.

- Gabriel

On Tue, Feb 10, 2015 at 11:14 AM, Thanaphol Prasitphaithoon <> wrote:

> Hi All
>  I use phoenix 4.2.2 and I bulk load csv file to phoenix. When I check
> records on timestamp column, records in table are different from csv. It
> like phoenix convert GMT time zone to ICT Timezone(ICT is my timezone). GMT
> is default time zone on phoenix.
> Does Phoenix has parameter to specific default timezone or other solution
> to suggest me to do.
> --
> Best Regards,
> Thanaphol Prasitphaithoon
> =========================
> Information Security Engineer
> Service Department
> Mindterra Company Limited
> Tel: (+66) 2530 2062-4
> Fax: (+66) 2530 2177
> Mobile: (+66) 84-022-0683
> E-mail: <>
> Website:
> Interact Mindterra via Facebook <> and
> Twitter <>

View raw message