question Re: Changing timezone in Phoenix Query Server in Archives of Support Questions (Read Only)

Changing timezone in Phoenix Query Server

muanang — Thu, 28 Jul 2016 08:54:54 GMT

Hi!

Sorry for a newbie question, but I just want to ask on how to change timezone on Phoenix.

Right now, by default it is set to GMT, and would like to change it to GMT+8.

Already tried to use this param below to Hbase, custom hbase-site.

phoenix.query.dateFormatTimeZone=GMT+08:00

But, still no luck.

Thanks in advance!

Best regards,

asinghal — Thu, 28 Jul 2016 15:46:13 GMT

can you check, updated configuration(hbase-site.xml) should be in the classpath of phoenix query server also?

sbhat — Thu, 28 Jul 2016 17:02:45 GMT

Alternately, if you are using ambari, you could add the property in the hbase service. Go to HBASE -> Configs ->

Custom hbase-site. Add the property phoenix.query.dateFormatTimeZone with value GMT+08:00. You may have to restart dependent services.

elserj — Tue, 02 Aug 2016 03:33:03 GMT

You might be able to change this in the client itself using the "timeZone" option in the Phoenix Thin Driver's JDBC URL:

muanang — Tue, 02 Aug 2016 08:14:08 GMT

Thanks @sbhat

muanang — Tue, 02 Aug 2016 08:14:22 GMT

honey_and_sw — Tue, 21 Feb 2017 20:40:21 GMT

Anyone did follow this answer and still got the same issue?

I added custom hbase-site in Ambari, but timezone wasn't changed. 😞