question Re: Phoenix timezone not changed in Archives of Support Questions (Read Only)

Phoenix timezone not changed

honey_and_sw — Tue, 21 Feb 2017 20:53:23 GMT

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!

Re: Phoenix timezone not changed

jgub — Tue, 21 Feb 2017 21:00:18 GMT

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

Re: Phoenix timezone not changed

honey_and_sw — Tue, 21 Feb 2017 21:18:59 GMT

@jgub

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

Re: Phoenix timezone not changed

jgub — Tue, 21 Feb 2017 22:21:04 GMT

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

Re: Phoenix timezone not changed

jgub — Tue, 21 Feb 2017 22:28:55 GMT

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?

Re: Phoenix timezone not changed

honey_and_sw — Tue, 21 Feb 2017 22:33:21 GMT

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'.

Re: Phoenix timezone not changed

honey_and_sw — Tue, 21 Feb 2017 22:50:03 GMT

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

Re: Phoenix timezone not changed

jgub — Wed, 22 Feb 2017 15:59:19 GMT

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

Re: Phoenix timezone not changed

honey_and_sw — Wed, 22 Feb 2017 21:39:18 GMT

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

Re: Phoenix timezone not changed

jgub — Thu, 23 Feb 2017 16:48:06 GMT

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