java多线程    Java入门    vsftp    ftp    linux配置    centos    FRP教程    HBase    Html5缓存    webp    zabbix    分布式    neo4j图数据库    

Hbase 命令行 shell基础

发表于 2020-02-08 09:47:09 by 月小升

第一部分：Hbase基础查看

1. Hbase版本查看

hbase(main):008:0> version
2.2.3, r6a830d87542b766bd3dc4cfdee28655f62de3974, 2020年 01月 10日 星期五 18:27:51 CST
Took 0.0002 seconds

2. Hbase状态查看命令shell

hbase(main):009:0> status
1 active master, 0 backup masters, 1 servers, 0 dead, 3.0000 average load
Took 0.0387 seconds

第二部分：DDL（Data Defination Language）操作，Hbase的表table的增删改查

1. 新建表test 设置两个列族为cf1,cf2

hbase(main):010:0> create 'test','cf1','cf2'
Created table test
Took 1.3418 seconds                                                             
=> Hbase::Table - test

2. 获取表的描述

hbase(main):011:0> describe 'test'
Table test is ENABLED                                                           
test                                                                            
COLUMN FAMILIES DESCRIPTION                                                     
{NAME => 'cf1', VERSIONS => '1', EVICT_BLOCKS_ON_CLOSE => 'false', NEW_VERSION_B
EHAVIOR => 'false', KEEP_DELETED_CELLS => 'FALSE', CACHE_DATA_ON_WRITE => 'false
', DATA_BLOCK_ENCODING => 'NONE', TTL => 'FOREVER', MIN_VERSIONS => '0', REPLICA
TION_SCOPE => '0', BLOOMFILTER => 'ROW', CACHE_INDEX_ON_WRITE => 'false', IN_MEM
ORY => 'false', CACHE_BLOOMS_ON_WRITE => 'false', PREFETCH_BLOCKS_ON_OPEN => 'fa
lse', COMPRESSION => 'NONE', BLOCKCACHE => 'true', BLOCKSIZE => '65536'}        
 
{NAME => 'cf2', VERSIONS => '1', EVICT_BLOCKS_ON_CLOSE => 'false', NEW_VERSION_B
EHAVIOR => 'false', KEEP_DELETED_CELLS => 'FALSE', CACHE_DATA_ON_WRITE => 'false
', DATA_BLOCK_ENCODING => 'NONE', TTL => 'FOREVER', MIN_VERSIONS => '0', REPLICA
TION_SCOPE => '0', BLOOMFILTER => 'ROW', CACHE_INDEX_ON_WRITE => 'false', IN_MEM
ORY => 'false', CACHE_BLOOMS_ON_WRITE => 'false', PREFETCH_BLOCKS_ON_OPEN => 'fa
lse', COMPRESSION => 'NONE', BLOCKCACHE => 'true', BLOCKSIZE => '65536'}        
 
2 row(s)
 
QUOTAS                                                                          
0 row(s)
Took 16.3063 seconds

3. 删除一个列族cf2

hbase(main):012:0> alter 'test', {NAME=>'cf2',METHOD=>'delete'}
Updating all regions with the new schema...
1/1 regions updated.
Done.
Took 2.0665 seconds

4. 列出所有Hbase里的表

hbase(main):013:0> list
TABLE                                                                           
table                                                                           
test                                                                            
2 row(s)
Took 0.0044 seconds                                                             
=> ["table", "test"]

5. 查询表是否存在

hbase(main):014:0> exists 'test'
Table test does exist                                                           
Took 0.0224 seconds                                                             
=> true

6. 查询表是否可用

hbase(main):015:0> is_enabled 'test'
true                                                                            
Took 0.0053 seconds                                                             
=> true

7. 删除一个表

hbase(main):017:0> disable 'test'
Took 0.4657 seconds                                                             
hbase(main):018:0> drop 'test'
Took 0.2485 seconds

第三部分：HBase的DML（Data Manipulation Language，数据操作语言）操作表的数据进行添加、修改、获取、删除和查询。


1. 插入数据
给Hbase的test表的row1行 插入两个列。

hbase(main):034:0> put 'test','row1','cf1:name','tom'
Took 0.0080 seconds                                                             
hbase(main):035:0> put 'test','row1','cf1:age','18'
Took 0.0043 seconds

列族cf1 定义了两个列 name 和 age

2. 读取数据
读取test 表的row1行的所有数据

hbase(main):036:0> get 'test','row1'
COLUMN                CELL                                                      
 cf1:age              timestamp=1581128757386, value=18                         
 cf1:name             timestamp=1581128743387, value=tom                        
1 row(s)
Took 0.0264 seconds

读取test row1行，列族cf1所有数据

hbase(main):037:0> get 'test','row1','cf1'
COLUMN                CELL                                                      
 cf1:age              timestamp=1581128757386, value=18                         
 cf1:name             timestamp=1581128743387, value=tom                        
1 row(s)
Took 0.0083 seconds

3. 更新一条记录
Hbase的更新语法和插入新数据语法一样

hbase(main):038:0> put 'test','row1','cf1:age','19'
Took 0.0059 seconds

查看更新结果

hbase(main):039:0> get 'test','row1','cf1:age'
COLUMN                CELL                                                      
 cf1:age              timestamp=1581130589721, value=19                         
1 row(s)
Took 0.0133 seconds

4. 通过时间戳读取两个版本的数据

hbase(main):005:0> get 'test','row1',{COLUMN=>'cf1:age',TIMESTAMP=>1581130589721}
COLUMN                CELL                                                      
 cf1:age              timestamp=1581130589721, value=19                         
1 row(s)
Took 0.0082 seconds 
 
hbase(main):008:0> get 'test','row1',{COLUMN=>'cf1:age',TIMESTAMP=>1581128757386}
COLUMN                CELL                                                      
 cf1:age              timestamp=1581128757386, value=18                         
1 row(s)
Took 0.0135 seconds

5. 全表扫描

hbase(main):009:0> scan 'test'
ROW                   COLUMN+CELL                                               
 row1                 column=cf1:age, timestamp=1581130589721, value=19         
 row1                 column=cf1:name, timestamp=1581128743387, value=tom       
1 row(s)
Took 0.0107 seconds

6.统计表中行数

hbase(main):017:0> count 'test'
1 row(s)
Took 0.0635 seconds                                                             
=> 1

7. 删除一列

hbase(main):011:0> delete 'test','row1','cf1:age'
Took 0.0269 seconds

检查删除的结果，年龄回到了18，把19那条删除了

hbase(main):012:0> get 'test','row1'
COLUMN                CELL                                                      
 cf1:age              timestamp=1581128757386, value=18                         
 cf1:name             timestamp=1581128743387, value=tom                        
1 row(s)
Took 0.0114 seconds

再次删除

hbase(main):015:0> delete 'test','row1','cf1:age'
Took 0.0030 seconds 
 
hbase(main):014:0> get 'test','row1'
COLUMN                CELL                                                      
 cf1:name             timestamp=1581128743387, value=tom                        
1 row(s)
Took 0.0134 seconds

8. 删除所有的单元格

hbase(main):020:0> deleteall 'test','row1'
Took 0.0041 seconds

9. 清空表所有数据

hbase(main):022:0> truncate 'test'
Truncating 'test' table (it may take a while):
Disabling table...
Truncating table...
Took 1.5547 seconds

This entry was posted in JAVA, 高并发与大数据 and tagged , . Bookmark the permalink.
月小升QQ 2651044202, 技术交流QQ群 178491360
首发地址：月小升博客 – https://java-er.com/blog/hbase-shell-command/
无特殊说明，文章均为月小升原创，欢迎转载，转载请注明本文地址，谢谢
您的评论是我写作的动力.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

*

  

  

专题-HBase

  1. Hbase scan 查询命令大全，前缀，模糊，正则
  2. Hbase 命令行 shell基础
  3. Hbase数据例子，及shell操作例子
  4. Java 实现 Hbase Scan 按行键范围扫描
  5. Java 连接Hbase代码 读取，写入，建库
  6. php 操作Hbase函数手册
  7. php连接Hbase 通过thrift
  8. 单机Hbase安装及基本命令
  9. 安装thrift
  10. 理解thrift的php和python版本教程

近期文章

  1. 程序员如何赚钱，财富自由
  2. Java的动态代理和静态代理
  3. Java是值传递还是引用传递
  4. 接口是否可以继承接口？抽象类是否可以实现(implements)接口？
  5. 接口和抽象类有什么不同
  6. Servlet 的生命周期，并说出Servlet 和CGI 的区别
  7. String、StringBuffer和StringBuilder类的区别
  8. 面向对象的三大特征
  9. 十万大小的数据集，从中选择10个最大的元素怎么做
  10. jdk排序算法分析

标签

    Android Apache cookie frp FTP google HBase html5 iphone java java基础教程 java教程 jQuery linux Linux命令 mac mac软件 MongoDB mysql neo4j nginx nosql php php-fpm php函数 python redis shell SVN swift Ubuntu Windows wordpress wordpress插件 xcode zabbix 值得记忆 图片 多线程 密码 插件 数据库 日志 服务器 缓存

分类

  1. JAVA
  2. Linux
  3. MAC
  4. Perl
  5. PHP
  6. Python
  7. WEB前端
  8. Windows
  9. 互联网观察
  10. 吐槽
  11. 技术管理
  12. 数学与算法
  13. 数据库
  14. 日常随笔
  15. 月小升软件
  16. 电商运营
  17. 科技精品
  18. 程序视点
  19. 网络推广
  20. 运营
  21. 阅读笔记
  22. 高并发与大数据