phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <>
Subject Re: RFE: using native HBase timestamp(version) to optimize date range queries in Phoenix
Date Sun, 06 Apr 2014 15:45:57 GMT
Hi Vladimir,
By default, Phoenix queries show you the "latest" data. You can override
this at connection time and do "flashback" queries, DDL, and DML as
described here:

What ever optimizations HBase does, Phoenix will see too, since at the end
of the day, we're issuing a regular set of scans.

Is this the kind of functionality for which you're looking? Or is it more
along the lines of a query returning multiple versions of the same row: This isn't supported yet.

Or maybe something else?


On Sat, Apr 5, 2014 at 10:42 AM, Vladimir Rodionov

> I am not sure it was implemented already, or it was not  ...
> It would be nice to have a way to tell Phoenix which column is naturally
> mapped to HBase timestamp. This will greatly improve range queries on
> this column by utilizing internal HBase optimizations (skipping store
> files, which are completely out of the specified timestamp range).
> -Vladimir Rodionov

View raw message