You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by Mich Talebzadeh <mi...@gmail.com> on 2016/10/23 12:45:33 UTC

Setting default timezone for Phoenix

Hi,

My queries in Phoenix pickup GMT timezone as default.

I need them to default to Europe/London by default

0: jdbc:phoenix:rhes564:2181> select CURRENT_DATE(),
CONVERT_TZ(CURRENT_DATE(), 'UTC', 'Europe/London');
+---------------------------------+---------------------------------+
| DATE '2016-10-23 12:38:02.434'  | DATE '2016-10-23 13:38:02.434'  |
+---------------------------------+---------------------------------+
| 2016-10-23 12:38:02.434         | 2016-10-23 13:38:02.434         |
+---------------------------------+---------------------------------+


I want to set this property in hbase-site.xml. This setting does not seem
to work

<property>
     <name>phoenix.query.dateFormatTimeZone</name>
     <value>Europe/London</value>
</property>


Thanks

Re: Setting default timezone for Phoenix

Posted by Ankit Singhal <an...@gmail.com>.

Hi Mich,

phoenix.query.dateFormatTimeZone is honored by functions which are listed
on a page[1] and their description has explicit mention of usage of this
property to override timezone from default GMT(For eg:[2]). so you need to
wrap other function with such function to convert the timezone like you did
in your example.

select CURRENT_DATE(), CONVERT_TZ(CURRENT_DATE());
+---------------------------------+---------------------------------+
| DATE '2016-10-23 12:38:02.434'  | DATE '2016-10-23 13:38:02.434'  |
+---------------------------------+---------------------------------+
| 2016-10-23 12:38:02.434         | 2016-10-23 13:38:02.434         |
+---------------------------------+---------------------------------+



I think we will update this property[3] with proper description to avoid
such confusion.

[1]https://phoenix.apache.org/language/functions.html
[2]https://phoenix.apache.org/language/functions.html#to_date
[3] https://phoenix.apache.org/tuning.html


Regards,
Ankit Singhal


On Sun, Oct 23, 2016 at 6:15 PM, Mich Talebzadeh <mi...@gmail.com>
wrote:

> Hi,
>
> My queries in Phoenix pickup GMT timezone as default.
>
> I need them to default to Europe/London by default
>
> 0: jdbc:phoenix:rhes564:2181> select CURRENT_DATE(),
> CONVERT_TZ(CURRENT_DATE(), 'UTC', 'Europe/London');
> +---------------------------------+---------------------------------+
> | DATE '2016-10-23 12:38:02.434'  | DATE '2016-10-23 13:38:02.434'  |
> +---------------------------------+---------------------------------+
> | 2016-10-23 12:38:02.434         | 2016-10-23 13:38:02.434         |
> +---------------------------------+---------------------------------+
>
>
> I want to set this property in hbase-site.xml. This setting does not seem
> to work
>
> <property>
>      <name>phoenix.query.dateFormatTimeZone</name>
>      <value>Europe/London</value>
> </property>
>
>
> Thanks
>
>
>