Phoenix client changes the timezone stored in table

Support Questions

Find answers, ask questions, and share your expertise

Explorer

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.