使用HBase shell进行表操作

梦里梦外; 2021-12-19 16:39 361阅读 0赞

**掌握使用HBase shell进行表操作**

## **（一）. 实验环境** ##

（章鱼大数据）HBase

## **（二）. 实验步骤** ##

1. 创建student表，表结构包含info和course列族，显示表结构。

create 'student','info','course'

![1539851-20181118134737908-732186333.png][]

2． 修改表结构，course列族返回最大版本数为3，显示表结构。

alter 'studemt',\{'NAME'=>'course','VERSIONS'=>'3'\}  
desc 'student'

![1539851-20181118134751628-744688704.png][]

3． 输入数据，要求至少包括以下列

（具体数据自定，course列族要输入部分小于60分的数据）

info列族：name、age、sex、dept

course列族：english、math、physics

put 'student','201601','info:name','liu',4  
put 'student','201601','info:age',15  
put 'student','201601','info:sex','nv'  
put 'student','201601','info:dept','PE'

put 'student','201602','info:name','wang'  
put 'student','201602','info:age',16,7  
put 'student','201602','info:sex','nan'  
put 'student','201602','info:dept','PC'

put 'student','201603','info:name','sun',6  
put 'student','201603','info:age',19  
put 'student','201603','info:sex','nv'  
put 'student','201603','info:dept','JAVA'

put 'student','201601','course:english',72,3  
put 'student','201601','course:math',79  
put 'student','201601','course:'physics',82

put 'student','201602','course:english',62  
put 'student','201602','course:math',68,8  
put 'student','201602','course:'physics',49

put 'student','201603','course:english',73,8  
put 'student','201603','course:math',69  
put 'student','201603','course:'physics',48,6

![1539851-20181118134901378-2096950180.png][]

![1539851-20181118134909997-1864885013.png][]

4． 更新数据，将course列族中小于60的数据更新为60。

put 'student','201602','course:physics',60  
put 'student','201603','course:physics',60

![1539851-20181118134918427-629291637.png][]

![1539851-20181118134926712-1134733600.png][]

5． 使用get进行数据查询。

get 'student','201601',\{COLUMN=>'course',TIMERANGE=>3\}

get 'student','201603',\{COLUMN=>'course',TIMERANGE=>\[6,8\]\}

![1539851-20181118134936022-82811683.png][]

6． 使用scan进行查询。

scan 'student',\{COLUMN => 'info:dept'\}

scan 'student',\{COLUMN => 'info:name'\}

![1539851-20181118134947797-907508429.png][]

7． 使用过滤器进行查询。

scan 'student',\{FILTER=>"TimestampFilter(3,8)"\}  
scan 'student',FILTER=>"RowFilter(=,'substring:2')"

![1539851-20181118134957978-1940693542.png][]

![1539851-20181118135005117-372992429.png][]

8． 创建student表的快照stu\_snap,显示快照列表。

snapshot 'student','stu\_snap'

list\_snapshots

![1539851-20181118135042177-2104010180.png][]

9． 通过快照stu\_snap生成新表stu\_info，并显示stu\_info表结构。

clone\_snapshot 'stu\_snap','stu\_info'

![1539851-20181118135050693-493673547.png][]

![1539851-20181118135059532-808709715.png][]

10. 删除快照stu\_snap，删除student表。

delete\_snapshot 'stu\_snap'

![1539851-20181118135110352-1536627839.png][]

![1539851-20181118135130062-966315624.png][]

##  （三）实验总结 ##

通过这次实验，我学会了Hbase的基本操作，即创建表、对表进行增删改查、利用过滤器查询以及一些快照操作。在创建表时应该注意字母的大小写，Hbase是区分大小写的；在删除表之前，需要先将表禁用，再进行删除；在使用过滤器查询时应注意单词拼写及大小写；snapshot命令可以建立表的快照。

转载于:https://www.cnblogs.com/xizhi--123/p/9977762.html

[1539851-20181118134737908-732186333.png]: /images/20211219/cb6cee0dd1fd4448b5458c668e1ed6ea.png
[1539851-20181118134751628-744688704.png]: /images/20211219/e01a7d5e45bf4b1aacb61ab7743ea9e2.png
[1539851-20181118134901378-2096950180.png]: /images/20211219/b17460a004424d80b3dcb3909592d059.png
[1539851-20181118134909997-1864885013.png]: /images/20211219/88cf9171dd524f75a9fd7081e03a830e.png
[1539851-20181118134918427-629291637.png]: /images/20211219/1e950d36b2bb41df987e30959e430c10.png
[1539851-20181118134926712-1134733600.png]: /images/20211219/8dd32474572f484dbc304adb630bcaab.png
[1539851-20181118134936022-82811683.png]: /images/20211219/61d89799961e4696a370aa7abc282e9f.png
[1539851-20181118134947797-907508429.png]: /images/20211219/56f33223fc1f414fb646537ad2b1c6b7.png
[1539851-20181118134957978-1940693542.png]: /images/20211219/1ea3d1f81303493e976c68af22f7ca88.png
[1539851-20181118135005117-372992429.png]: /images/20211219/5c5f50467f79488986e7074a47bb799a.png
[1539851-20181118135042177-2104010180.png]: /images/20211219/51072951e41249a580e1dfc141a03f73.png
[1539851-20181118135050693-493673547.png]: /images/20211219/8905dfc8d0914d9d8bd00c6650742ab0.png
[1539851-20181118135059532-808709715.png]: /images/20211219/6c7dee65edea430886ce0ca9d139877b.png
[1539851-20181118135110352-1536627839.png]: /images/20211219/c417eb0f78b5492e866ef37e614d69fa.png
[1539851-20181118135130062-966315624.png]: /images/20211219/d3695afe98904fc68c479dc700f79cd9.png