phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Singhal <ankitsingha...@gmail.com>
Subject Re: Setting default timezone for Phoenix
Date Sun, 23 Oct 2016 13:08:56 GMT
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 <mich.talebzadeh@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
>
>
>

Mime
View raw message