Hello,
It seems that Phoenix still doesn't support using LIKE in
correlated-subqueries. I tried the following query:
select W.rowId
from Wiki AS W
where NOT EXISTS (
select * from History AS H
where (H.rowId like W.rowId || '%') AND (H.status = 'pending');
and it gave me the error:
Error: Does
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
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 not
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