HBase常用命令整理

DDL

describe 'table'

count 'table', INTERVAL => 100000

scan 'table',{LIMIT=>10}

truncate 'table'

enable 'table'

disable 'table'

drop 'table'

统计行数

$HBASE_HOME/bin/hbase org.apache.hadoop.hbase.mapreduce.RowCounter 'tablename'

DML

create 'tb', 'cf1', 'cf2'

put 'tb', 'rk', 'cf:qf', 'val', ts

get 'tb', 'rk', {COLUMN => 'cf', TIMESTAMP => ts, VERSIONS => ver}

get 'tb', 'rk', {COLUMN => ['cf1', 'cf2', 'cf3'], TIMERANGE => [ts1, ts2], VERSIONS => ver}



scan '.META.', {COLUMNS => 'info:regioninfo'}

scan 'tb', {COLUMNS => ['cf1', 'cf2'], LIMIT => 10, STARTROW => 'xxx'}

scan 't1', {FILTER => “(PrefixFilter ('row2') AND (QualifierFilter (>=, 'binary:xyz'))) AND (TimestampsFilter(123, 456))”}

scan 't1', {FILTER => org.apache.hadoop.hbase.filter.ColumnPaginationFilter.new(1, 0)}



delete 'tb', 'cf', 'qf'

delete 'tb', 'rk', 'cf1', ts1



disable 'tb'

alter 'tb', NAME=>'cf1', VERSIONS => 5 // 改变或添加一个列族

/alter 'tb', NAME => 'cf2', METHOD => 'delete' // 删除一个列族

/alter 'tb', 'delete' => 'cf3' // 删除一个列族

/alter 'tb', METHOD => 'table_att', MAX_FILESIZE => '134217728' // 修改表属性，如MAX_FILESIZE\

/alter 'tb', METHOD => 'table_att_unset', NAME => 'MAX_FILESIZE' // 移除表属性

alter 'tb', {NAME => 'cf1'}, {NAME => 'cf2', METHOD => 'delete'} // 执行多个alter命令

enable 'tb'



count 'tb'

count 'tb', INTERVAL => 100000

count 'tb', CACHE => 1000

count 'tb', INTERVAL => 10, CACHE => 1000