hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew Purtell <apurt...@yahoo.com>
Subject Re: Q, Paging
Date Tue, 25 Nov 2008 19:42:31 GMT
If you are using trunk you can consider secondary indexes
(HBASE-883):

    https://issues.apache.org/jira/browse/HBASE-883

You need to run regionserver.tableindexed.IndexedRegionServer
instead of standard HRegionServer and client side you'll
need to use the classes in client.tableindexed, but this will
"transparently" (more or less) support scanners that return
rows in ascending sort order on the column data of your
choice. Secondary indexes must be established at table
creation time by using IndexedTableAdmin to create the table.

You can create any number of secondary indexes on a table.

This has not been well tested so if you do use it and 
encounter a problem, please file a report.  

   - Andy

> Edward J. Yoon wrote:
> Let's assume that row key is a email address, a unique
> identifier for login user and also a sender & receiver.
> and column families are meta data. (e.g. from, to, cc,
> bcc, reply-to, subject, content, ..., etc) And, the
> inbox will display the page as describe below:
> 
> ID (row key) : edward@udanax.org
> Inbox(3849)
> ----
> from:edward | subject:"hello there"
> from:hadoop | subject:"[jira] update ..."
> ....
>
> Then, I need to sort and page them by historical receive
> mails. Is it possible? If so, what is the best way to do
> pagination on column key results?
>
> If it won't solved by one table, what is the best schema?



      

Mime
View raw message