Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Phoenix query server timezone not changing in what is set in hbase config via ambari

Highlighted

Phoenix query server timezone not changing in what is set in hbase config via ambari

New Contributor

Here are the details:

0: jdbc:phoenix:localhost> UPSERT INTO test(ID,DATE) VALUES(125,NOW());
1 row affected (0.018 seconds)
0: jdbc:phoenix:localhost> select * from test;
+------------------------------------------+-------------------------+
| ID | DATE |
+------------------------------------------+-------------------------+
| 125 | 2019-11-05 05:15:42.058 |
| 124 | 2019-11-05 05:14:52.153 |
| 123 | 2019-11-05 04:55:06.983 |
+------------------------------------------+-------------------------+
3 rows selected (0.064 seconds)
0: jdbc:phoenix:localhost>

 

I've set the timezone to GMT+8 via ambari of the phoenix query server. However, it displays always in UTC format.. Any suggestions. Thanks

Don't have an account?
Coming from Hortonworks? Activate your account here