阿輝的零碎筆記

Login

hbase shell

help

Get the description to all command.

Version

hbase(main):002:0> version
2.1.6.3.1.5.95-1, rUnknown, Mon Aug 24 10:07:41 UTC 2020
Took 0.0012 seconds

whoami

hbase(main):003:0> whoami
grayyin@test.test (auth:KERBEROS)
Took 0.4917 seconds

create_namespace

hbase(main):006:0> create_namespace 'test_namespace'

list_namespace_tables

hbase(main):013:0> list_namespace_tables 'test_namespace'
TABLE
testtable1
1 row(s)

create 'table name', 'column family 1', 'column family 2', ...

hbase(main):033:0> create 'test_namespace:test_table1', 'columnfamily1'
Created table test_namespace:test_table1
Took 18.3644 seconds

describe

hbase(main):034:0> describe 'test_namespace:test_table1'
Table test_namespace:test_table1 is ENABLED
test_namespace:test_table1
COLUMN FAMILIES DESCRIPTION
{NAME => 'columnfamily1', VERSIONS => '1', EVICT_BLOCKS_ON_CLOSE => 'false', NEW_VERSION_BEHAVIOR => 'false', KEEP_DELETED_CELLS => 'FALSE', CACHE_DATA_ON_WRITE => 'false', DATA
_BLOCK_ENCODING => 'NONE', TTL => 'FOREVER', MIN_VERSIONS => '0', REPLICATION_SCOPE => '0', BLOOMFILTER => 'ROW', CACHE_INDEX_ON_WRITE => 'false', IN_MEMORY => 'false
', CACHE_BLOOMS_ON_WRITE => 'false', PREFETCH_BLOCKS_ON_OPEN => 'false', COMPRESSION => 'NONE', BLOCKCACHE => 'true', BLOCKSIZE => '65536'}
1 row(s)
Took 0.0209 seconds

list & list_namespace

hbase(main):010:0> list_namespace
NAMESPACE
default

get
get 'table name', 'row key', 'column family:qualifier'

put
put 'table name', 'row key', 'column family:qualifier', 'value'

scan
scan 'table name'

List the rowkey start with rowkeyInitXXXX
EX:

hbase(main):005:0> scan 'test_namespace:test_table1', FILTER => "PrefixFilter ('rowkeyInit')"

scan filter by {$keyword1} & {$keyword2}

EX:

hbase(main):006:0> scan "test_nampspace:test_table", { FILTER => "SingleColumnValueFilter('columnfamily1', 'column1', =,'binary:{$keyword1}') AND SingleColumnValueFilter('columnfamily1','column2',=,'binary:{$keyword2}')"}

Datetime filter

EX:

hbase(main):019:0* scan 'test_nampspace:test_table', FILTER => "SingleColumnValueFilter('columnfamily1', 'datetime_type_column' ,>, 'binary:2021-04-15 06:25:29.02') AND SingleColumnValueFilter('columnfamily1', 'datetime_type_column' ,>, 'binary:2021-04-15 07:25:29.02')"

 

delete
delete 'table name', 'row key', 'column family:qualifier'

drop table
disable 'table name'

drop 'table name'

hbase(main):031:0* disable 'test_namespace'
Took 6.2468 seconds
hbase(main):032:0> drop 'test_namespace'
Took 8.3564 seconds

deleteall
deleteall 'table name', 'row key'