Hiya,

Richard (and Istvan) had a chat with me the other day about the change Richard has started making here.

Given what I know so far, I think Richard is trying to fix a long-standing "it just is that way"-ism from Phoenix.

Please give it a glance and make sure we're working towards a proper long-term fix :). Thanks!


-------- Forwarded Message --------
Subject: [jira] [Comment Edited] (PHOENIX-5066) The TimeZone is incorrectly used during writing or reading data
Date: Tue, 2 Jun 2020 12:51:00 +0000 (UTC)
From: Richard Antal (Jira) <[email protected]>
To: [email protected]


[ https://issues.apache.org/jira/browse/PHOENIX-5066?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17123679#comment-17123679 ]
Richard Antal edited comment on PHOENIX-5066 at 6/2/20, 12:50 PM:
------------------------------------------------------------------

I created a [pull request|[https://github.com/apache/phoenix/pull/796]] to make it easier to see the differences. In the latest patch I changed the static functions in the DateUtil class to non static. We can get the DateUtil instance by calling the getDateUtilContext on PhoenixConnection, this way we can set the timezone attribute for the DateUtil when we create the connection and use it later.

This change looks huge because DateUtil was replaced to getDateUtilContext everywhere.

There are lot of failing tests outside of GMT time zones, because this patch introduces a new behaviour for timezone handling. Strings that are parsed to time are not interpreted in GMT/UTC but in local timezone and we store the data in GMT or in QueryServices.DATE_FORMAT_TIMEZONE_ATTRIB if that is set to some other value.

I would like to hear other opinions about this change before doing any further modification.


Reply via email to