Phoenix timezone not changed

[#1]

Hi all,

I have a Spark app which inserts data to HBase, using Phoenix. They're managed inside Ambari. And more, I use Squirrel SQL as Phoenix GUI tool.

I added phoenix.query.dateFormatTimeZone option to custom hbase-site.xml of Ambari, but timezone never be changed. KST, GMT+9:00, ... several format all do not have affect.

-- MODIFIED

But with ./sqlline.py, expected timezone is used.

Thanks in advance!

[#2 · Accepted solution]

Could you please check if you use sqlline.py instead of Squirrel SQL is the problem occurs?

[#3]

@jgub

yup, it looks like sqlline.py works. Then maybe Squirrel SQL has the problem?

[#4]

Yes, I think it will be something related to the Squirrel SQL timezone settings.

[#5]

Could you try to run Squirell SQL in the changed time zone by setting the "-Duser.timezone=<timezone>" JVM parameter?

On what operating system are you running Squirell SQL?

[#6]

Hmm It doesn't work on Mac OS. You meant MacOS/squirrel-sql.sh right?

[#7]

Got it. One more question : is it possible to insert Date of custom timezone to Phoenix? it looks like dateFormatTimeZone is only related to 'select and interpret date', not to 'insert date'.

[#8]

How about https://phoenix.apache.org/language/functions.html#to_date ?

[#9]

I've been noticed them and also considered timestamp, but am finding more clearer solution : ) Thanks anyways.

[#10]

Could you link or summarize it here for further reference? 🙂