hbase-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "chunhui shen (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HBASE-10114) _scan_internal() in table.rb should accept argument that specifies reverse scan
Date Tue, 10 Dec 2013 03:09:09 GMT

     [ 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)

Mime
View raw message