[ 
https://issues.apache.org/jira/browse/HBASE-7474?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13542617#comment-13542617
 ] 

Anil Gupta commented on HBASE-7474:
-----------------------------------

[~ted_yu]
My implementation is purely based on Sorting on a column value. That previous 
comment was just an example. My implementation also takes the startIndex and 
pageSize. So, it handles more than Top N. If accidentally, it suffices  
HBASE-5982, then it's great!

Ted: I think the above assumption is not realistic. The rows would spread 
across 10 regions.
Anil: It depends on the use case. Obviously, a scan can span 10 or more region 
also. In my use case, barely a request will even span more than 2-3 
regions(around 2-3 million records with scan range). HBase has wide variety of 
use-case so using this feature is at user discretion.

I developed this feature for one of my use case. I thought that this would be a 
good additional feature in HBase. Hence, i decided to commit it. I am not 
trying to push this forcefully into HBase distrinution. If it doesn't seems 
like a perfect fit then please let me know.

                
> Endpoint Implementation to support Scans with Sorting of Rows based on column 
> values(similar to "order by" clause of RDBMS)
> ---------------------------------------------------------------------------------------------------------------------------
>
>                 Key: HBASE-7474
>                 URL: https://issues.apache.org/jira/browse/HBASE-7474
>             Project: HBase
>          Issue Type: New Feature
>          Components: Coprocessors, Scanners
>    Affects Versions: 0.94.3
>            Reporter: Anil Gupta
>            Priority: Minor
>              Labels: coprocessors, scan, sort
>             Fix For: 0.94.5
>
>         Attachments: SortingEndpoint_high_level_flowchart.pdf
>
>
> Recently, i have developed an Endpoint which can sort the Results(rows) on 
> the basis of column values. This functionality is similar to "order by" 
> clause of RDBMS. I will be submitting this Patch for HBase0.94.3
> I am almost done with the initial development and testing of feature. But, i 
> need to write the JUnits for this. I will also try to make design doc.
> Thanks,
> Anil Gupta
> Software Engineer II, Intuit, inc

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to