先电大数据平台操作手册-iandian-bigdata-v2.1

2 row(s) in seconds 4) drop一个表

hbase(main):029:0>disable 'temp_table' 0 row(s) in

hbase(main):030:0>drop 'temp_table' 0 row(s) in

5) 判断表是否enable

hbase(main):016:0> is_enabled 'member'

true 0 row(s) in seconds 6) 判断表是否disable

hbase(main):032:0>is_disabled 'member'

false 0 row(s) in 3. DML操作 1) 插入几条记录

put'member','scutshuxue','info:age','24'

put'member','scutshuxue','info:birthday','1987-06-17' put'member','scutshuxue','info:company','alibaba' put'member','scutshuxue','address:contry','china' put'member','scutshuxue','address:province','zhejiang' put'member','scutshuxue','address:city','hangzhou' put'member','xiaofeng','info:birthday','1987-4-17' put'member','xiaofeng','info:favorite','movie' put'member','xiaofeng','info:company','alibaba' put'member','xiaofeng','address:contry','china'

put'member','xiaofeng','address:province','guangdong' put'member','xiaofeng','address:city','jieyang' put'member','xiaofeng','address:town','xianqiao' 2) 获取一条数据 获取一个id的所有数据

hbase(main):003:0> get 'member','scutshuxue'

COLUMN CELL

address:city timestamp=, value=hangzhou

address:contry timestamp=, value=china

address:province timestamp=, value=zhejiang

info:age timestamp=, value=24

info:birthday timestamp=, value=1987-06-17

info:company timestamp=, value=alibaba 6 row(s) in seconds

获取一个id的所有数据获取一个id，一个列族中一个列的所有数据 hbase(main):026:0> get 'member','scutshuxue','info'

COLUMN CELL

info:age timestamp=, value=24

info:birthday timestamp=, value=1987-06-17

info:company timestamp=, value=alibaba 3 row(s) in seconds 3) .更新一条记录

hbase(main):027:0> put 'member','scutshuxue','info:age' ,'99' 0 row(s) in seconds

4) 通过timestamp来获取两个版本的数据

hbase(main):028:0> get 'member','scutshuxue',{COLUMN=>'info:age',TIMESTAMP=>}

COLUMN CELL

0 row(s) in seconds 5) 全表扫描

hbase(main):029:0> scan 'member'

ROW COLUMN+CELL scutshuxue column=address:city, timestamp=, value=hangzhou scutshuxue column=address:contry, timestamp=, value=china scutshuxue column=address:province, timestamp=, value=zhejiang scutshuxue column=info:age, timestamp=, value=99 scutshuxue column=info:birthday, timestamp=, value=1987-06-17 scutshuxue column=info:company, timestamp=, value=alibaba xiaofeng column=address:city, timestamp=, value=jieyang xiaofeng column=address:contry, timestamp=, value=china xiaofeng column=address:province, timestamp=, value=guangdong xiaofeng column=address:town, timestamp=, value=xianqiao xiaofeng column=info:birthday, timestamp=, value=1987-4-17 xiaofeng column=info:company, timestamp=,

value=alibaba xiaofeng column=info:favorite, timestamp=, value=movie 2 row(s) in seconds

6) 删除id为temp的值的‘info:age’字段

hbase(main):030:0> delete 'member','temp','info:age' 0 row(s) in seconds 7) 删除整行

hbase(main):031:0> deleteall 'member','xiaofeng' 0 row(s) in seconds 8) 查询表中有多少行

hbase(main):032:0> count 'member' 1 row(s) in seconds => 1

9) 给‘xiaofeng’这个id增加'info:age'字段，并使用counter实现递增获 hbase(main):033:0> incr 'member','xiaofeng','info:age' COUNTER VALUE = 1 0 row(s) in seconds

取当前count的值hbase(main):034:0> get_counter 'member','xiaofeng','info:age' COUNTER VALUE = 1 10) 将整张表清空

hbase(main):035:0> truncate 'member'

Truncating 'member' table (it may take a while): - Disabling table... - Truncating table... 0 row(s) in seconds

7.2.3 运行案例

1. 导入用户数据表

将文件上传到HDFS文件系统中： # hadoop fs -put /data/hbase/ # hadoop fs -ls /data/hbase/ 在HBase中创建user表：

hbase(main):003:0> create 'user','info' 0 row(s) in seconds => Hbase::Table – user

运行MapReduce任务，导入数据，首先生成Hfile文件： #

hbase

=\

=HBASE_ROW_KEY,info:name,info:age

user

，可以看到生成的HFile文件

将HFile数据导入user表中： # hbase user