HBase1.4.6安装搭建及shell命令使用( 五 ) _生活百科

5、DML5.1 插入或者修改数据put

文章插图
# 语法# 当列族中只有一个列时'列族名:列名'使用'列族名'put '表名', '行键', '列族名', '列值'put '表名', '行键', '列族名:列名', '列值'# 示例# 创建表create 'users', 'info', 'detail', 'address'# 第一行数据put 'users', 'rk1001', 'info:id', '1'put 'users', 'rk1001', 'info:name', '张三'put 'users', 'rk1001', 'info:age', '28'put 'users', 'rk1001', 'detail:birthday', '1990-06-26'put 'users', 'rk1001', 'detail:email', 'abc@163.com'put 'users', 'rk1001', 'detail:create_time', '2019-03-04 14:26:10'put 'users', 'rk1001', 'address', '上海市'# 第二行数据put 'users', 'rk1002', 'info:id', '2'put 'users', 'rk1002', 'info:name', '李四'put 'users', 'rk1002', 'info:age', '27'put 'users', 'rk1002', 'detail:birthday', '1990-06-27'put 'users', 'rk1002', 'detail:email', 'xxx@gmail.com'put 'users', 'rk1002', 'detail:create_time', '2019-03-05 14:26:10'put 'users', 'rk1002', 'address', '北京市'# 第三行数据put 'users', 'rk1003', 'info:id', '3'put 'users', 'rk1003', 'info:name', '王五'put 'users', 'rk1003', 'info:age', '26'put 'users', 'rk1003', 'detail:birthday', '1990-06-28'put 'users', 'rk1003', 'detail:email', 'xyz@qq.com'put 'users', 'rk1003', 'detail:create_time', '2019-03-06 14:26:10'put 'users', 'rk1003', 'address', '杭州市'5.2 全表扫描scan# 语法scan '表名'# 示例scan 'users'

文章插图

扫描整个列簇

# 语法scan '表名', {COLUMN=>'列族名'}# 示例scan 'users', {COLUMN=>'info'}

扫描整个列簇的某个列

# 语法scan '表名', {COLUMN=>'列族名:列名'}# 示例scan 'users', {COLUMN=>'info:age'}5.3获取数据get# 语法get '表名', '行键'# 示例get 'users', 'xiaoming'

根据某一行某列族的数据

# 语法get '表名', '行键', '列族名'# 示例get 'users', 'xiaoming', 'info'# 创建表，c1版本为4，元数据mykey=myvaluehbase(main):009:0> create 't1', {NAME => 'c1', VERSIONS => 4}, METADATA => { 'mykey' => 'myvalue' }0 row(s) in 2.2810 seconds=> Hbase::Table - t1# 添加列族c2, c3hbase(main):010:0> alter 't1', 'c2', 'c3'Updating all regions with the new schema...1/1 regions updated.Done.Updating all regions with the new schema...1/1 regions updated.Done.0 row(s) in 3.8320 seconds# 出入数据，c1 插入4个版本的值hbase(main):011:0> put 't1', 'r1', 'c1', 'v1'0 row(s) in 0.1000 secondshbase(main):012:0> put 't1', 'r1', 'c1', 'v11'0 row(s) in 0.0180 secondshbase(main):013:0> put 't1', 'r1', 'c1', 'v111'0 row(s) in 0.0140 secondshbase(main):014:0> put 't1', 'r1', 'c1', 'v1111'0 row(s) in 0.0140 seconds# 插入c2、c3的值hbase(main):015:0> put 't1', 'r1', 'c2', 'v2'0 row(s) in 0.0140 secondshbase(main):016:0> put 't1', 'r1', 'c3', 'v3'0 row(s) in 0.0210 seconds# 获取rowKey=r1的一行记录hbase(main):017:0> get 't1', 'r1'COLUMN CELL c1: timestamp=1552819382575, value=https://www.huyubaike.com/biancheng/v1111 c2: timestamp=1552819392398, value=v2 c3: timestamp=1552819398244, value=v33 row(s) in 0.0550 seconds# 获取rowKey=r1并且 1552819392398