hbase-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepak Sharma (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HBASE-9942) hbase Scanner specifications accepting wrong specifier and then after scan using correct specifier returning unexpected result
Date Mon, 11 Nov 2013 10:18:17 GMT
Deepak Sharma created HBASE-9942:
------------------------------------

             Summary: hbase Scanner specifications accepting wrong specifier and then after
scan using correct specifier returning unexpected result 
                 Key: HBASE-9942
                 URL: https://issues.apache.org/jira/browse/HBASE-9942
             Project: HBase
          Issue Type: Bug
          Components: Client
    Affects Versions: 0.94.13
            Reporter: Deepak Sharma
            Priority: Minor


check the given scenerio:
1. log in to hbase client --> ./hbase shell
2. created table 'tab1' 
hbase(main):001:0> create 'tab1' , 'fa1'
3. put some 10 rows (row1 to row10)  in table 'tab1'
4.  run the scan for table 'tab1' as follows:
 
hbase(main):013:0> scan 'tab1' , { STARTROW => 'row4' , STOPROW => 'row9' }
ROW                                       COLUMN+CELL                                    
                                                                         
 row4                                     column=fa1:col1, timestamp=1384164182738, value=value1
                                                                  
 row5                                     column=fa1:col1, timestamp=1384164188396, value=value1
                                                                  
 row6                                     column=fa1:col1, timestamp=1384164192395, value=value1
                                                                  
 row7                                     column=fa1:col1, timestamp=1384164197693, value=value1
                                                                  
 row8                                     column=fa1:col1, timestamp=1384164203237, value=value1
                                                                  
5 row(s) in 0.0540 seconds

so result was expected , rows from 'row4' to 'row8' are displayed

5. then run the scan using wrong specifier ( '=' instead of '=>') so get wrong result
hbase(main):014:0> scan 'tab1' , { STARTROW = 'row4' , STOPROW = 'row9' }
ROW                                       COLUMN+CELL                                    
                                                                         
 row1                                     column=fa1:col1, timestamp=1384164167838, value=value1
                                                                  
 row10                                    column=fa1:col1, timestamp=1384164212615, value=value1
                                                                  
 row2                                     column=fa1:col1, timestamp=1384164175337, value=value1
                                                                  
 row3                                     column=fa1:col1, timestamp=1384164179068, value=value1
                                                                  
 row4                                     column=fa1:col1, timestamp=1384164182738, value=value1
                                                                  
 row5                                     column=fa1:col1, timestamp=1384164188396, value=value1
                                                                  
 row6                                     column=fa1:col1, timestamp=1384164192395, value=value1
                                                                  
 row7                                     column=fa1:col1, timestamp=1384164197693, value=value1
                                                                  
 row8                                     column=fa1:col1, timestamp=1384164203237, value=value1
                                                                  
 row9                                     column=fa1:col1, timestamp=1384164208375, value=value1
                                                                  
10 row(s) in 0.0390 seconds

6. now performed correct scan query with correct specifier ( used '=>' as specifier)
hbase(main):015:0> scan 'tab1' , { STARTROW => 'row4' , STOPROW => 'row9' }
ROW                                       COLUMN+CELL                                    
                                                                         
 row1                                     column=fa1:col1, timestamp=1384164167838, value=value1
                                                                  
 row10                                    column=fa1:col1, timestamp=1384164212615, value=value1
                                                                  
 row2                                     column=fa1:col1, timestamp=1384164175337, value=value1
                                                                  
 row3                                     column=fa1:col1, timestamp=1384164179068, value=value1
                                                                  
 row4                                     column=fa1:col1, timestamp=1384164182738, value=value1
                                                                  
 row5                                     column=fa1:col1, timestamp=1384164188396, value=value1
                                                                  
 row6                                     column=fa1:col1, timestamp=1384164192395, value=value1
                                                                  
 row7                                     column=fa1:col1, timestamp=1384164197693, value=value1
                                                                  
 row8                                     column=fa1:col1, timestamp=1384164203237, value=value1
                                                                  
 row9                                     column=fa1:col1, timestamp=1384164208375, value=value1
                                                                  
10 row(s) in 0.0450 seconds

now even if i have passed correct scan query then also i am getting wrong result 

Defect:
check in step 6 as per scan query , only row4 to row9 should be displayed but output result
is displaying all the rows in this table 

Note: when i exit the shell and again loging and perform the same query then result was correct



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message