About honey_and_sw

honey_and_sw · ‎02-22-2017

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

honey_and_sw · ‎02-21-2017

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

honey_and_sw · ‎02-21-2017

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

honey_and_sw · ‎02-21-2017

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

honey_and_sw · ‎02-21-2017

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!

honey_and_sw · ‎02-21-2017

Anyone did follow this answer and still got the same issue? I added custom hbase-site in Ambari, but timezone wasn't changed. 😞

Online	Offline
Last Visited	‎05-16-2017 07:40 AM

Member Since	‎02-21-2017 12:36 PM
Last Visited	‎05-16-2017 07:40 AM
Posts	9

Cloudera Community

Re: Phoenix timezone not changed

Re: Phoenix timezone not changed

Re: Phoenix timezone not changed

Re: Phoenix timezone not changed

Phoenix timezone not changed

Re: Changing timezone in Phoenix Query Server