kudu-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Patrick Angeles <patr...@cloudera.com>
Subject Re: Reverse sort on Primary Key
Date Mon, 23 Apr 2018 20:25:47 GMT
The common technique is to use (MAX_LONG - timestamp). Unfortunately this
won't let you toggle the sort order back-and-forth on the same table. You
could have a duplicate table with the inverse key, effectively using it as
a secondary index.

As of version 0.98, HBase supports a reverse scan without a 'secondary
index' table (HBASE-4811), so with a bit of work Kudu may be able to
provide something similar.

Patrick Angeles
Chief Architect Financial Services
151 West 26th Street Suite 1002 | New York, NY 10001
+1 (917) 633-4524

On Sat, Apr 21, 2018 at 10:36 PM, Scott Reynolds <sdrreynolds@gmail.com>

> Today we are using Kudu  to store timeseries information and would like
> the ability to toggle the sort direction. It is unclear to me at the moment
> how to achieve this efficiently. I naively assumed Kudu could read the
> primary key in reverse but there doesn't appear to be the case ATM.
> If you were tasked with implementing a reverse sort on the primary key
> (Date Desc) how would you go about implementing it ?
> Thanks!

View raw message