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 client changes the timezone stored in table

Highlighted

Phoenix client changes the timezone stored in table

New Contributor

My linux box timezone is in GMT and when I query the tables, it shows correct tz in phoenix (sqlline). When I remotely connect and query the same tables, the timestamp data converts to PST.

When I say remotely connect, meaning I am using aqua data studio to connect and the same issue occurs when I connect via Application.

I tried to add the property in hbase-site.xml, but there is no luck. Can you please let me know what do I need to do to get the exact data stored in phoenix/hbase table without tz conversion.