大师网-带你快速走向大师之路 解决你在学习过程中的疑惑,带你快速进入大师之门。节省时间,提升效率

HBASE操作(1)-HBASE Shell

  • 启动命令
    ./hbase shell

  • 退出命令
    exit

  • 创建表
    create '表名称', '列族名称1','列族名称2','列族名称N'
    create 'users','user_id','address','info'

  • 列出全部表
    list

  • 得到表的描述
    describe 'users'

  • 删除表
    disable 'users' drop 'users'

  • 添加记录
    put ‘表名称’, ‘行键', '列名称:', '值'

put 'users','xiaoming','info:age','24'
put 'users','xiaoming','info:birthday','1987-06-17'
put 'users','xiaoming','info:company','alibaba'
put 'users','xiaoming','address:contry','china'
put 'users','xiaoming','address:province','zhejiang'
put 'users','xiaoming','address:city','hangzhou'
put 'users','zhangyifei','info:birthday','1987-4-17'
put 'users','zhangyifei','info:favorite','movie'
put 'users','zhangyifei','info:company','alibaba'
put 'users','zhangyifei','address:contry','china'
put 'users','zhangyifei','address:province','guangdong'
put 'users','zhangyifei','address:city','jieyang'
put 'users','zhangyifei','address:town','xianqiao'
  • 获取一条记录
    get '表名称', '行键'

  • 取得一个id的所有数据
    get 'users','xiaoming'

  • 获取一个id,一个列族的所有数据
    get 'users','xiaoming','info'

  • 获取一个id,一个列族中一个列的所有数据
    get 'users','xiaoming','info:age'

  • 更新记录(重新写一遍覆盖)

put 'users','xiaoming','info:age' ,'29'
get 'users','xiaoming','info:age'
put 'users','xiaoming','info:age' ,'30'
get 'users','xiaoming','info:age'
  • 获取单元格数据的版本数据
get 'users','xiaoming',{COLUMN=>'info:age',VERSIONS=>1}
get 'users','xiaoming',{COLUMN=>'info:age',VERSIONS=>2}
get 'users','xiaoming',{COLUMN=>'info:age',VERSIONS=>3}
  • 获取单元格数据的某个版本数据

get 'users','xiaoming',{COLUMN=>'info:age',TIMESTAMP=>1364874937056}

  • 全表扫描
    scan 'users'

  • 查看某个表某个列中所有数据
    scan "表名称" , {COLUMNS=>'列族名称:列名称'}

  • 删除xiaoming值的'info:age'字段
    delete '表名' ,'行键' , '列名称'
    delete 'users','xiaoming','info:age' get 'users','xiaoming'

  • 删除整行
    deleteall 'users','xiaoming'

  • 统计表的行数
    count '表名称'
    count 'users'

  • 清空表
    truncate 'users'