You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hbase.apache.org by "Andrew Kyle Purtell (Jira)" <ji...@apache.org> on 2022/06/16 18:32:00 UTC
[jira] [Resolved] (HBASE-9942) hbase Scanner specifications accepting wrong specifier and then after scan using correct specifier returning unexpected result
[ https://issues.apache.org/jira/browse/HBASE-9942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrew Kyle Purtell resolved HBASE-9942.
----------------------------------------
Resolution: Incomplete
> 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.96.0, 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
(v8.20.7#820007)