数据:9万条
1 采用rowfilter查询
scan 'testImportCsv',{FILTER => RowFilter.new(CompareFilter::CompareOp.valueOf('EQUAL'), SubstringComparator.new('1130210018008161'))}
时间是:0.2400s
2 采用值过滤查询
scan 'testImportCsv',{FILTER => ValueFilter.new(CompareFilter::CompareOp.valueOf('EQUAL'), SubstringComparator.new('130210018008161'))}
时间:0.4160
3 采用rowkey查询
get 'testImportCsv','32_63885PYZ1130210018008161'
综上所述:
rowkey过滤是值过滤查询速度的10~20倍
直接根据rowkey查询的速度是rowkey过滤查询的20倍往上
end:使用rowkey过滤多值时
3218条
scan 'testImportCsv',{FILTER => RowFilter.new(CompareFilter::CompareOp.valueOf('EQUAL'), SubstringComparator.new('PYZ4'))}
用时16秒左右