Support Questions
Find answers, ask questions, and share your expertise

Phoenix client changes the timezone stored in table

Phoenix client changes the timezone stored in table

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.