[ 
https://issues.apache.org/jira/browse/HBASE-10114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

chunhui shen updated HBASE-10114:
---------------------------------

    Description: 
Reversed Scan usage on Shell:
hbase> scan 't1', {REVERSED => true}
Other parameter could also be added with 'REVERSED', like LIMIT,COLUMNS.

Examples:

hbase(main):019:0* scan 't1'
ROW                                      COLUMN+CELL                            
                                                                             
 001                                     column=f1:q1, timestamp=1386644670350, 
value=v1                                                                     
 002                                     column=f1:q2, timestamp=1386644675585, 
value=v1                                                                     
 003                                     column=f1:q1, timestamp=1386644680090, 
value=v1                                                                     
 003                                     column=f1:q2, timestamp=1386644682749, 
value=v1                                                                     
 004                                     column=f1:q1, timestamp=1386644692589, 
value=v1                                                                     
4 row(s) in 0.0130 seconds


hbase(main):022:0> scan 't1',{REVERSED => true}
ROW                                      COLUMN+CELL                            
                                                                             
 004                                     column=f1:q1, timestamp=1386644692589, 
value=v1                                                                     
 003                                     column=f1:q1, timestamp=1386644680090, 
value=v1                                                                     
 003                                     column=f1:q2, timestamp=1386644682749, 
value=v1                                                                     
 002                                     column=f1:q2, timestamp=1386644675585, 
value=v1                                                                     
 001                                     column=f1:q1, timestamp=1386644670350, 
value=v1    


hbase(main):023:0> scan 't1',{REVERSED => true,COLUMNS=>'f1:q2'}
ROW                                      COLUMN+CELL                            
                                                                             
 003                                     column=f1:q2, timestamp=1386644682749, 
value=v1                                                                     
 002                                     column=f1:q2, timestamp=1386644675585, 
value=v1                                                                     
2 row(s) in 0.0100 seconds


Here is how boolean argument is accepted:
{code}
        cache_blocks = args["CACHE_BLOCKS"] || true
{code}
Flag for reverse scan should be supported in similar manner

  was:
Reversed Scan usage on Shell:
hbase> scan 't1', {REVERSED => true}
Other parameter could also be added with 'REVERSED', like LIMIT,COLUMNS.

Examples:

hbase(main):019:0* scan 't1'
ROW                                      COLUMN+CELL                            
                                                                             
 001                                     column=f1:q1, timestamp=1386644670350, 
value=v1                                                                     
 002                                     column=f1:q2, timestamp=1386644675585, 
value=v1                                                                     
 003                                     column=f1:q1, timestamp=1386644680090, 
value=v1                                                                     
 003                                     column=f1:q2, timestamp=1386644682749, 
value=v1                                                                     
 004                                     column=f1:q1, timestamp=1386644692589, 
value=v1                                                                     
4 row(s) in 0.0130 seconds


hbase(main):022:0> scan 't1',{REVERSED => true}
ROW                                      COLUMN+CELL                            
                                                                             
 004                                     column=f1:q1, timestamp=1386644692589, 
value=v1                                                                     
 003                                     column=f1:q1, timestamp=1386644680090, 
value=v1                                                                     
 003                                     column=f1:q2, timestamp=1386644682749, 
value=v1                                                                     
 002                                     column=f1:q2, timestamp=1386644675585, 
value=v1                                                                     
 001                                     column=f1:q1, timestamp=1386644670350, 
value=v1    


hbase(main):023:0> scan 't1',{REVERSED => true,COLUMNS=>'f1:q2'}
ROW                                      COLUMN+CELL                            
                                                                             
 003                                     column=f1:q2, timestamp=1386644682749, 
value=v1                                                                     
 002                                     column=f1:q2, timestamp=1386644675585, 
value=v1                                                                     
2 row(s) in 0.0100 seconds

{code}


Here is how boolean argument is accepted:
{code}
        cache_blocks = args["CACHE_BLOCKS"] || true
{code}
Flag for reverse scan should be supported in similar manner


> _scan_internal() in table.rb should accept argument that specifies reverse 
> scan
> -------------------------------------------------------------------------------
>
>                 Key: HBASE-10114
>                 URL: https://issues.apache.org/jira/browse/HBASE-10114
>             Project: HBase
>          Issue Type: Bug
>            Reporter: Ted Yu
>             Fix For: 0.98.0, 0.99.0
>
>         Attachments: hbase-10114-trunk.patch
>
>
> Reversed Scan usage on Shell:
> hbase> scan 't1', {REVERSED => true}
> Other parameter could also be added with 'REVERSED', like LIMIT,COLUMNS.
> Examples:
> hbase(main):019:0* scan 't1'
> ROW                                      COLUMN+CELL                          
>                                                                               
>  
>  001                                     column=f1:q1, 
> timestamp=1386644670350, value=v1                                             
>                         
>  002                                     column=f1:q2, 
> timestamp=1386644675585, value=v1                                             
>                         
>  003                                     column=f1:q1, 
> timestamp=1386644680090, value=v1                                             
>                         
>  003                                     column=f1:q2, 
> timestamp=1386644682749, value=v1                                             
>                         
>  004                                     column=f1:q1, 
> timestamp=1386644692589, value=v1                                             
>                         
> 4 row(s) in 0.0130 seconds
> hbase(main):022:0> scan 't1',{REVERSED => true}
> ROW                                      COLUMN+CELL                          
>                                                                               
>  
>  004                                     column=f1:q1, 
> timestamp=1386644692589, value=v1                                             
>                         
>  003                                     column=f1:q1, 
> timestamp=1386644680090, value=v1                                             
>                         
>  003                                     column=f1:q2, 
> timestamp=1386644682749, value=v1                                             
>                         
>  002                                     column=f1:q2, 
> timestamp=1386644675585, value=v1                                             
>                         
>  001                                     column=f1:q1, 
> timestamp=1386644670350, value=v1    
> hbase(main):023:0> scan 't1',{REVERSED => true,COLUMNS=>'f1:q2'}
> ROW                                      COLUMN+CELL                          
>                                                                               
>  
>  003                                     column=f1:q2, 
> timestamp=1386644682749, value=v1                                             
>                         
>  002                                     column=f1:q2, 
> timestamp=1386644675585, value=v1                                             
>                         
> 2 row(s) in 0.0100 seconds
> Here is how boolean argument is accepted:
> {code}
>         cache_blocks = args["CACHE_BLOCKS"] || true
> {code}
> Flag for reverse scan should be supported in similar manner



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)

Reply via email to