Hadoop之——Hbase Shell命令

標籤：hadoop   mapreduce   叢集   hbase   

轉載請註明出處:http://blog.csdn.net/l1028386804/article/details/46463503

HBASE Shell

進入Habse資料庫終端：#$HBASE_HOME/bin/hbase shell

建立表

>create‘users‘,‘user_id‘,‘address‘,‘info‘

表users,有三個列族user_id,address,info

列出全部表

>list

得到表的描述

>describe ‘users

建立表

>create‘users_tmp‘,‘user_id‘,‘address‘,‘info‘

刪除表

>disable ‘users_tmp‘

>drop ‘users_tmp‘

添加記錄

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‘;

擷取一條記錄1.取得一個id的所有資料

>get ‘users‘,‘xiaoming‘

2.擷取一個id，一個列族的所有資料

>get ‘users‘,‘xiaoming‘,‘info‘

3.擷取一個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‘

刪除xiaoming值的‘info:age‘欄位

>delete ‘users‘,‘xiaoming‘,‘info:age‘

>get ‘users‘,‘xiaoming‘

刪除整行

>deleteall ‘users‘,‘xiaoming‘

統計表的行數

>count ‘users‘

清空表>truncate‘users‘

Hadoop之——Hbase Shell命令