HBase shell的DDL和DML

======================DDL=======================
查看当前hbase集群的状况
status

查看版本
version

查看所有的表
list

创建表
create 'student','student_id','address','info'

student:表名
student_id、address、info：列族(column family)

查看表结构
describe 'student'

删除列族(cf)
alter 'student','delete'=>'student_id'

查看表是否存在
exists 'student'

删除表
disable 'student'(先禁用)
drop 'student'(在删除)


========================DML======================

创建member表

create 'member','info','address'

查看表的内容
语法: scan '表名'
举例: scan 'member'


插入数据
语法: put '表名','rowkey','列族名:列名','值'
举例:
put 'member','zhangsan','info:gender','male'
put 'member','zhangsan','info:age','18'
put 'member','zhangsan','address:province','hebei'
put 'member','zhangsan','address:city','shijiazhuang'


删除数据
删除单元格内容语法: delete '表名','rowkey','列族名:列名'
举例: delete 'member','zhangsan','info:gender'


删除整行语法: deleteall '表名','rowkey'
举例: deleteall 'member','zhangsan'


修改数据(修改操作和添加操作的语法是一样的，只不过是把之前的内容覆盖掉)
语法: put '表名','rowkey','列族名:列名','值'
举例: put 'member','zhangsan','info:gender','female'


查询数据
查询整行语法: get '表名','rowkey'
举例: get 'member','zhangsan'


查询指定列族数据语法: get '表名','rowkey',{COLUMN => '列族'}
举例: get 'member','zhangsan',{COLUMN => 'info'}


查询指定列数据语法: get '表名','rowkey',{COLUMN => '列族:列名'}
举例: get 'member','zhangsan',{COLUMN => 'info:gender'}