Hbase Scan returning data out of range

Question

I was doing a scan using startRowKey and StopRowKey in HBase scan using HBase shell, but the output what I am receiving is outside the range passed. Please refer the Hbase Query -

import org.apache.hadoop.hbase.filter.CompareFilter
import org.apache.hadoop.hbase.filter.SingleColumnValueFilter
import org.apache.hadoop.hbase.filter.SubstringComparator
import org.apache.hadoop.hbase.util.Bytes


scan 'TableName',{ LIMIT => 2 , STARTROW => '000|9223370554721275807', STOPROW => '101|9223370554727575807', FILTER => SingleColumnValueFilter.new(Bytes.toBytes('col_family'), Bytes.toBytes('col_qualifier'), CompareFilter::CompareOp.valueOf('EQUAL'), Bytes.toBytes('Some Value')), COLUMNS => 'col_family:col_qualifier', REVERSED => false}

But the out what is received is outside this range -

016|9223370554960173487

021|9223370555154148992

Please let me know is my search query is correct or what could be the root cause for this?? Any help will be really appreciated.

Thanks

Answer 1

If you put the four rowkeys mentioned in your question in a file and sort them the result will be:

000|9223370554721275807
016|9223370554960173487
021|9223370555154148992
101|9223370554727575807

Thus the values you received are not outside the range of your scan.