Hbase常规shell操作

1. namespace

   1. 查看所有的namespace
      list_namespace

   2. 创建namespace
      create_namespace ‘mydb’
      create_namespace ‘mydb1’,{‘author’=>‘wyh’,‘createtime’=>‘2021-06-25’}

   3. 查看namespace详情
      describe_namespace ‘mydb’

   4. 修改namespace
      alter_namespace ‘ns1’, {METHOD => ‘set’, ‘PROPERTY_NAME’ => ‘PROPERTY_VALUE’}
      alter_namespace ‘ns1’, {METHOD => ‘unset’, NAME=>‘PROPERTY_NAME’}

   5. 查看namespace下面的表
      list_namespace_tables ‘mydb’

   6. 删除namespace
      drop_namespace ‘mydb’

2. Table - DDL

1. 查看所有的表
   list

2. 创建表
   create ‘t1’,{NAME=>‘info’}
   create ‘t2’,{NAME=>‘info’},{NAME=>‘info1’}
   create ‘t3’,{NAME=>‘info’,VERSIONS=>‘3’}

   create ‘t4’,‘info’,‘info1’

3. 查看表的详情
   describe ‘t1’
   desc ‘t1’

4. 修改表
   alter ‘t1’, NAME=>‘info1’
   alter ‘t1’, ‘delete’=>‘info1’
   alter ‘t3’, NAME=>‘info’,VERSIONS=>‘2’

5. 删除表
   disable ‘t1’
   drop ‘t1’

3. Table - DML

1. 插入数据
   put ‘stu’,‘1001’,‘info:name’,‘zhangsan’
   put ‘stu’,‘1001’,‘info:sex’,‘man’
   put ‘stu’,‘1001’,‘info:age’,‘30’

   put ‘stu’,‘1002’,‘info:name’,‘lisi’
   put ‘stu’,‘1002’,‘info:sex’,‘man’

   put ‘stu’,‘10021’,‘info:name’,‘manman’
   put ‘stu’,‘10021’,‘info:sex’,‘women’
   put ‘stu’,‘10021’,‘info:age’,‘18’

   put ‘stu’,‘1003’,‘info:name’,‘xiaohua’
   put ‘stu’,‘1003’,‘info:sex’,‘women’
   put ‘stu’,‘1003’,‘info:age’,‘30’
   put ‘stu’,‘1003’,‘info:address’,‘beijing’

   put ‘stu’,‘1004’,‘info:name’,‘xiaohong’
   put ‘stu’,‘1004’,‘info:sex’,‘women’
   put ‘stu’,‘1004’,‘info:age’,‘30’
   put ‘stu’,‘1004’,‘info:address’,‘beijing’
   put ‘stu’,‘1004’,‘info1:tel’,‘110’
   put ‘stu’,‘1004’,‘info1:hobby’,‘code’

2. 查询数据
   get ‘stu’,‘1001’
   get ‘stu’,‘1001’,[‘info:name’,‘info:sex’]

3. 扫描数据
   scan ‘stu’
   scan ‘stu’,{STARTROW=>‘1001’ ,STOPROW=>‘1003’}
   scan ‘stu’,{STARTROW=>‘1001’ ,STOPROW=>‘10021’}
   scan ‘stu’,{STARTROW=>‘1001’ ,STOPROW=>‘1002!’}
   scan ‘stu’,{STARTROW=>‘1001’ ,STOPROW=>‘1002|’}

4. 修改数据
   put ‘stu’,‘1001’,‘info:name’,‘zhangxiaosan’

5. 删除数据
   delete ‘stu’,‘1001’,‘info:name’ 删除指定版本的数据(默认删除最新版本)
   deleteall ‘stu’,‘1001’,‘info:name’ 删除指定列所有版本的数据
   deleteall ‘stu’,‘1001’ 删除一行数据(删除所有列族的数据)