Setting default timezone for Phoenix

Sun, 23 Oct 2016 05:45:51 -0700 

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

Reply via email to