Hbase shell常用命令

[anneng]

1.只查询 key 注意：这个返回的不是 rowkey
hbase(main):018:0> scan 'emp',{ FILTER => "KeyOnlyFilter()"}

ROW COLUMN+CELL
1 column=personal_data:city, timestamp=1501587154609, value=
1 column=personal_data:name, timestamp=1501587131490, value=
10 column=personal_data:city, timestamp=1501590338062, value=
11 column=personal_data:city, timestamp=1501590380498, value=

2.将shell的结果保存到本地
echo "scan 'test_use',{FILTER =>"(PrefixFilter ('4'))"}"|hbase shell>hbase.txt

3.只保存 rowkey
echo "count 'nt', { INTERVAL => 1 }"|hbase shell>nt_rowkeys.txt
4.查询rowkey中包括特殊字符的行
import org.apache.hadoop.hbase.filter.CompareFilter
import org.apache.hadoop.hbase.filter.SingleColumnValueFilter
import org.apache.hadoop.hbase.filter.SubstringComparator

scan 'TableName', {FILTER => org.apache.hadoop.hbase.filter.RowFilter.new(CompareFilter::CompareOp.valueOf('EQUAL'),SubstringComparator.new("se@@"))}

5.查询含有某些值的列
hbase> import org.apache.hadoop.hbase.filter.SingleColumnValueFilter

hbase> import org.apache.hadoop.hbase.filter.CompareFilter

hbase> import org.apache.hadoop.hbase.filter.BinaryComparator
hbase> scan 'Table_Name', { FILTER => SingleColumnValueFilter.new(Bytes.toBytes('Column Family'), Bytes.toBytes('ColumnName'), CompareFilter::CompareOp.valueOf('EQUAL'),BinaryComparator.new(Bytes.toBytes('Column Value')))}