hbase2.1.x shell scan RowFilter

RowFilter

根据 rowkey 过滤,显示整行数据

相当于mysql根据id查询:select * from 表 where id=1000

构造方法

https://hbase.apache.org/2.1/devapidocs/org/apache/hadoop/hbase/filter/RowFilter.html

RowFilter(CompareOperator op, ByteArrayComparable rowComparator)

解释:

  • 第一个形参是:比较运算符:=、>、>=、<、<=
  • 第二个形参是:表达式

例子

scan 'student',{FILTER => "RowFilter(=,'binary:1000')",FORMATTER=>'toString',COLUMNS =>['info:name','info:age']}

相当于 sql:select name,age from student where id=1000

显示结果:

ROW                                                      COLUMN+CELL
 1000                                                    column=info:age, timestamp=1632556052813, value=20
 1000                                                    column=info:name, timestamp=1632570790706, value=李雷                                                                                                                
1 row(s)
Took 0.0134 seconds

原文出处:/show_1IX1vaxh76Nk.html