常用hbase shell 命令

hbase shell

list

create_namespace 'mytest'

create 'mytest:test01', {NAME => 'cf', VERSIONS => 1}

put 'mytest:test01', '001', 'cf:name', '张三'
put 'mytest:test01', '001', 'cf:age', '26'
put 'mytest:test01', '001', 'cf:sex', '男'

put 'mytest:test01', '002', 'cf:name', 'Lily'
put 'mytest:test01', '002', 'cf:age', '20'
put 'mytest:test01', '002', 'cf:sex', '女'

get 'mytest:test01','001'
get 'mytest:test01','001','cf:name'

scan 'mytest:test01'

deleteall 'mytest:test01','001'
deleteall 'mytest:test01','002'

truncate_preserve 'mytest:test01'

disable 'mytest:test01'
drop 'mytest:test01'

条件查询

scan 'mytest:test01',{STARTROW=>'null',LIMIT=>10}

scan 'mytest:test01',FILTER=>"RowFilter(=,'substring:202006')",LIMIT=>1

count 'mytest:test01',FILTER=>"RowFilter(=,'substring:202004')",INTERVAL=>10000

scan 'mytest:test01',{ROWPREFIXFILTER=>'10-65-202004',LIMIT=>10}

count 'mytest:test01',{ROWPREFIXFILTER=>'10-65-202004'}

scan 'mytest:test01',{FILTER=>  "TimestampsFilter (1596592807000,1596603307000)",LIMIT=>10}
scan 'mytest:test01', { FILTER => "(ValueFilter (>=, '201709'))",LIMIT=>1}

scan mytest:test01,{TIMERANGE=>[1589507400000,1589526923000],FILTER=>"RowFilter(=,'substring:202004')",LIMIT=>1}

scan 'mytest:test01',{TIMERANGE=>[1589507400000,1589526923000],ROWPREFIXFILTER=>'-',LIMIT=>1}

scan 'mytest:test01',{TIMERANGE=>[1596592807000,1596600007000],LIMIT=>2}

hbase shell 将结果输出到文件

echo "scan 'mytest:test01', {COLUMNS => ['cf:name','cf:sex']}" | hbase shell > /data/home/hbase_data/test01.txt

执行脚本：hbase shell mytest.txt,mytest.txt内容：

scan 'mytest:test01'
exit

执行命令把memstore刷新到Hfile中

flush 'mytest'

flush后可查看hbase mytest表保存在hdfs中的数据：

hdfs dfs -ls /hbase/data/default/mytest

原创不易，转载请注明出处