RE: Timezones in Phoenix

2015-04-17 Thread Matthew Johnson
] *Sent:* 16 April 2015 20:09 *To:* user@phoenix.apache.org *Subject:* Re: Timezones in Phoenix Hi Matt, How are you viewing the timestamps (or in other words, how are you verifying that they're not in GMT)? The reason I ask is because internally in Phoenix, timestamps are used with

Re: Timezones in Phoenix

2015-04-16 Thread Gabriel Reid
Hi Matt, How are you viewing the timestamps (or in other words, how are you verifying that they're not in GMT)? The reason I ask is because internally in Phoenix, timestamps are used without a timezone (they're just based on a long, as you've saved in your table). However, the java.sql.Timestamp'

Re: Timezones in Phoenix

2015-04-16 Thread Billy Watson
The unsigned date specifically says, "The purpose of this type is to map to existing HBase data that was serialized using this HBase utility method." When you stored these values, did you use that method? According to the docs, "If that is not the case, use the regular signed type instead." I'm no

Timezones in Phoenix

2015-04-16 Thread Matthew Johnson
Hi all, I have a bunch of millisecond timestamps stored in HBase as Long values. I have a Phoenix view that reads these values as an UNSIGNED_DATE. Now that the clocks have gone forwards, the Phoenix driver has automatically applied the timezone change and as a result all of my Long values are b