热门标签
热门文章
- 1词嵌入技术(Word Embeddings)：算法原理，操作步骤，数学公式，代码实例，详细例子一步一步的说明等_为数据集设计词嵌入方法的步骤
- 2HTTP基本认证(Basic Authentication)的JAVA示例_java http basic authentication
- 3in use 大学英语4word_(完整word版)全新版大学英语第四册综合教程课后翻译答案及课文译文...
- 4Poe！集齐4大 AI 聊天工具的神器，再也不同担心用不上 ChatGPT 了~_poe注册
- 5pandas基础教程：(Dataframe操作/ Series操作/读取CSV文件/读取npy文件/pandas与numpy/数据科学)_dataframe 读取csv
- 622年我在CSDN做到了名利兼收_csdn博客 赚钱
- 7Verilog功能模块——读写位宽不同的同步FIFO_位宽不一样的fifo
- 8【git】从零实现git到github的连接和上传文件（最完整）
- 9secure boot 基本概念和框架
- 10CSDN可以修改发帖内容吗_csdn 发布文章后没办法修改嘛
当前位置: article > 正文
HBase Shell基本操作
作者：笔触狂放9 | 2024-05-27 20:21:28
赞
踩
hbase shell基本操作
一、进入Hbase Shell客户端
先在Linux Shell命令行终端执行start-dfs.sh脚本启动HDFS，再执行start-hbase.sh脚本启动HBase。如果Linux系统已配置HBase环境变量，可直接在任意目录下执行hbase shell脚本命令，就可进入HBase Shell的命令行终端环境，exit可以退出HBase Shell（我安装的是伪分布式的HBase）。
（1） help帮助命令（或者help '命令名称'查看某一具体命令的使用方法）
- hbase:055:0> help
- HBase Shell, version 2.5.6, r6bac842797dc26bedb7adc0759358e4c8fd5a992, Sat Oct 14 23:36:46 PDT 2023
- Type 'help "COMMAND"', (e.g. 'help "get"' -- the quotes are necessary) for help on a specific command.
- Commands are grouped. Type 'help "COMMAND_GROUP"', (e.g. 'help "general"') for help on a command group.
-
- COMMAND GROUPS:
- Group name: general
- Commands: processlist, status, table_help, version, whoami
-
- Group name: ddl
- Commands: alter, alter_async, alter_status, clone_table_schema, create, describe, disable, disable_all, drop, drop_all, enable, enable_all, exists, get_table, is_disabled, is_enabled, list, list_regions, locate_region, show_filters
-
- Group name: namespace
- Commands: alter_namespace, create_namespace, describe_namespace, drop_namespace, list_namespace, list_namespace_tables
-
- Group name: dml
- Commands: append, count, delete, deleteall, get, get_counter, get_splits, incr, put, scan, truncate, truncate_preserve
二、General通用操作命令
（1）status：查看HBase集群状态
- hbase:051:0> status
- 1 active master, 0 backup masters, 1 servers, 0 dead, 5.0000 average load
- Took 2.3419 seconds
（2）version：查看HBase版本信息
- hbase:052:0> version
- 2.5.6, r6bac842797dc26bedb7adc0759358e4c8fd5a992, Sat Oct 14 23:36:46 PDT 2023
- Took 0.0029 seconds
（3）whoami：查看当前登录HBase的系统用户信息
- hbase:053:0> whoami
- root (auth:SIMPLE)
- groups: root
- Took 0.1906 seconds
（4）table_help：查看HBase数据表操作的帮助信息
- table_help
- Help for table-reference commands.
-
- You can either create a table via 'create' and then manipulate the table via commands like 'put', 'get', etc.
- See the standard help information for how to use each of these commands.
三、Namespace操作
namespace(命名空间)是HBase对数据表的逻辑分组，用于数据表的业务划分。例如上层应用可以不同业务的数据表分别放置在不同的名字空间，以实现不同业务数据表之间的数据隔离。命名空间和数据表是一对多关系，命名空间可以包含多张数据表，一张数据表只能属于一个名字空间。HBase数据库中的NameSpace类似于MySQL数据库中的database。 命名空间是HBASE对数据表的逻辑分组，用于数据表的业务划分。
（1）list_namespace:查询所有命名空间
- hbase:036:0> list_namespace
- NAMESPACE
- default
- hbase
- ns1
- 3 row(s)
- Took 0.0654 seconds
（2）list_namespace_tables : 查询指定命名空间的表
- hbase:038:0> list_namespace_tables 'ns1'
- TABLE
- t1
- 1 row(s)
- Took 0.1958 seconds
- => ["t1"]
（3）create_namespace : 创建指定的命名空间
- hbase:039:0> create_namespace 'ns2'
- Took 0.4516 seconds
（4）describe_namespace : 查询指定命名空间的结构
- hbase:041:0> describe_namespace 'ns2'
- DESCRIPTION
- {NAME => 'ns2'}
（5）alter_namespace ：修改命名空间的结构
- hbase:045:0> alter_namespace 'ns2',{METHOD=>'set','authore'=>'Mike'}
- Took 1.6665 seconds
- hbase:046:0> describe_namespace 'ns2'
- DESCRIPTION
- {NAME => 'ns2', author => 'Mike'}
- Quota is disabled
- Took 0.2023 seconds
- hbase:047:0> alter_namespace 'ns2',{METHOD=>'unset','NAME'=>'author'}
- Took 0.1602 seconds
- hbase:048:0> describe_namespace 'ns2'
- DESCRIPTION
- {NAME => 'ns2'}
- Quota is disabled
- Took 0.0878 seconds
（6）drop_namespace：删除命名空间
- hbase:049:0> drop_namespace 'ns2'
- Took 0.4194 seconds
- hbase:050:0> list_namespace
- NAMESPACE
- default
- hbase
- ns1
- 3 row(s)
- Took 0.0610 seconds
四、DDL操作命令
DDL分组中包含的操作命令很多，主要用于对HBase数据库表的相关管理操作，主要包括创建表、修改表、删除表、列出表、启用表、禁用表等操作。
（1）create:建表（建表的时候，必须至少指定一个列族名称）
在默认的命名空间中，创建表students，并包含一个名为info的列族，列族属性默认。
- #如果保留默认的列族设置，建表时直接写列族的名字就可以了
- hbase:070:0> create 'students','info'
- 2024-03-21 00:25:59,140 INFO [main] client.HBaseAdmin (HBaseAdmin.java:postOperationResult(3591)) - Operation: CREATE, Table Name: default:students, procId: 131 completed
- Created table students
- Took 3.4314 seconds
- => Hbase::Table - students
在指定的ns1命名空间中，创建表t1，并包含一个名为f1的列族，列族属性自定义。
- #建表的同时指定列族属性
- hbase:071:0> create 'ns1:t1',{NAME=>'f1',VERSIONS=>5}
- 2024-03-21 00:28:43,872 INFO [main] client.HBaseAdmin (HBaseAdmin.java:postOperationResult(3591)) - Operation: CREATE, Table Name: ns1:t1, procId: 134 completed
- Created table ns1:t1
- Took 2.3465 seconds
- => Hbase::Table - ns1:t1
（2）list : 查询所有的表
- hbase:072:0> list
- TABLE
- students
- ns1:t1
- 2 row(s)
- Took 0.2459 seconds
- => ["students", "ns1:t1"]
（3）describe/desc : 查询表结构
- hbase:074:0> describe 'students'
- Table students is ENABLED
- students, {TABLE_ATTRIBUTES => {METADATA => {'hbase.store.file-tracker.impl' => DEFAULT'}}}
- COLUMN FAMILIES DESCRIPTION
- {NAME => 'info', INDEX_BLOCK_ENCODING => 'NONE', VERSIONS => '1', KEEP_DELETED_CELLS => 'FALSE'
- , DATA_BLOCK_ENCODING => 'NONE', TTL => 'FOREVER', MIN_VERSIONS => '0', REPLICATION_SCOPE => '0
- ', BLOOMFILTER => 'ROW', IN_MEMORY => 'false', COMPRESSION => 'NONE', BLOCKCACHE => 'true', BLO
- CKSIZE => '65536 B (64KB)'}
- 1 row(s)
- Quota is disabled
- Took 1.1379 seconds
（4）exists : 判断指定表明是否存在
- hbase:075:0> exists 'ns1:t1'
- Table ns1:t1 does exist
- Took 0.0714 seconds
- => true
（5）alter：修改表，添加、修改、删除列簇信息
为students表格，增加一个列族score。
- hbase:076:0> alter 'students','score'
- Updating all regions with the new schema...
- 1/1 regions updated.
- Done.
- Took 3.8994 seconds
- hbase:077:0> desc 'students'
- Table students is ENABLED
- students, {TABLE_ATTRIBUTES => {METADATA => {'hbase.store.file-tracker.impl' => 'DEFAULT'}}}
- COLUMN FAMILIES DESCRIPTION
- {NAME => 'info', INDEX_BLOCK_ENCODING => 'NONE', VERSIONS => '1', KEEP_DELETED_CELLS => 'FALSE'
- , DATA_BLOCK_ENCODING => 'NONE', TTL => 'FOREVER', MIN_VERSIONS => '0', REPLICATION_SCOPE => '0
- ', BLOOMFILTER => 'ROW', IN_MEMORY => 'false', COMPRESSION => 'NONE', BLOCKCACHE => 'true', BLO
- CKSIZE => '65536 B (64KB)'}
-
- {NAME => 'score', INDEX_BLOCK_ENCODING => 'NONE', VERSIONS => '1', KEEP_DELETED_CELLS => 'FALSE
- ', DATA_BLOCK_ENCODING => 'NONE', TTL => 'FOREVER', MIN_VERSIONS => '0', REPLICATION_SCOPE => '
- 0', BLOOMFILTER => 'ROW', IN_MEMORY => 'false', COMPRESSION => 'NONE', BLOCKCACHE => 'true', BL
- OCKSIZE => '65536 B (64KB)'}
-
- 2 row(s)
- Quota is disabled
- Took 0.0753 seconds
修改表格students的列族score的属性VERSIONS的值为5。
- hbase:078:0> alter 'students',NAME=>'score',VERSIONS=>5
- Updating all regions with the new schema...
- 1/1 regions updated.
- Done.
- Took 1.9776 seconds
删除表格表格students的列族score。
- hbase:079:0> alter 'students',NAME=>'score',METHOD=>'delete'
- Updating all regions with the new schema...
- 1/1 regions updated.
- Done.
- Took 2.5517 seconds
- hbase:080:0> desc 'students'
- Table students is ENABLED
- students, {TABLE_ATTRIBUTES => {METADATA => {'hbase.store.file-tracker.impl' =>'DEFAULT'}}}
- COLUMN FAMILIES DESCRIPTION
- {NAME => 'info', INDEX_BLOCK_ENCODING => 'NONE', VERSIONS => '1', KEEP_DELETED_CELLS => 'FALSE'
- , DATA_BLOCK_ENCODING => 'NONE', TTL => 'FOREVER', MIN_VERSIONS => '0', REPLICATION_SCOPE => '0
- ', BLOOMFILTER => 'ROW', IN_MEMORY => 'false', COMPRESSION => 'NONE', BLOCKCACHE => 'true', BLO
- CKSIZE => '65536 B (64KB)'}
- 1 row(s)
- Quota is disabled
- Took 0.2625 seconds
（6）disable：禁用表格
- hbase:083:0> disable 'students'
- 2024-03-21 00:52:29,298 INFO [main] client.HBaseAdmin (HBaseAdmin.java:rpcCall(926)) - Started disable of students
- 2024-03-21 00:52:29,810 INFO [main] client.HBaseAdmin (HBaseAdmin.java:postOperationResult(3591)) - Operation: DISABLE, Table Name: default:students, procId: 158 completed
- Took 0.5354 seconds
（7）enable：启用表格
- hbase:084:0> enable 'students'
- 2024-03-21 00:52:51,239 INFO [main] client.HBaseAdmin (HBaseAdmin.java:rpcCall(866)) - Started enable of students
- 2024-03-21 00:52:51,882 INFO [main] client.HBaseAdmin (HBaseAdmin.java:postOperationResult(3591)) - Operation: ENABLE, Table Name: default:students, procId: 161 completed
- Took 0.6636 seconds
（8）drop：删除表格（先要disable表，再删除表）
- hbase:085:0> disable 'ns1:t1'
- 2024-03-21 00:53:34,360 INFO [main] client.HBaseAdmin (HBaseAdmin.java:rpcCall(926)) - Started disable of ns1:t1
- 2024-03-21 00:53:34,727 INFO [main] client.HBaseAdmin (HBaseAdmin.java:postOperationResult(3591)) - Operation: DISABLE, Table Name: ns1:t1, procId: 164 completed
- Took 0.3910 seconds
- hbase:086:0> drop 'ns1:t1'
- 2024-03-21 00:53:43,300 INFO [main] client.HBaseAdmin (HBaseAdmin.java:postOperationResult(3591)) - Operation: DELETE, Table Name: ns1:t1, procId: 167 completed
- Took 0.7044 seconds
- hbase:087:0> list
- TABLE
- students
- 1 row(s)
- Took 0.0301 seconds
- => ["students"]
五、DML操作命令
DML包含的操作命令很多，主要用于对数据表中的数据进行操作，主要包括全表扫描、读取单行数据、写入数据和删除数据等操作。
（1）put：插入数据（put命令，不能一次性插入多条）
往students表格的info列族，增加2条数据：
行键为s001，列限定符name，单元格值Jack；行键为s001，列限定符age，单元格值20；
往students表格的score列族，增加2条数据：
行键为s001，列限定符Chinese，单元格值90；行键为s001，列限定符Math，单元格值85；
- hbase:088:0> put 'students','s001','info:name','Jack'
- Took 2.2121 seconds
- hbase:092:0> put 'students','s001','info:age','20'
- Took 0.0543 seconds
- hbase:096:0> put 'students','s001','score:Chinese','90'
- Took 0.0380 seconds
- hbase:097:0> put 'students','s001','score:Math','85'
- Took 0.0148 seconds
修改students表格的单元格值：行键为s001，列限定符name，单元格值'Jack'修改为'Mike'。
- hbase:089:0> put 'students','s001','info:name','Mike'
- Took 0.2027 seconds
（2）get：查询数据
查询students表格，行键为s001的所有数据。
- hbase:098:0> get 'students','s001'
- COLUMN CELL
- info:age timestamp=2024-03-21T01:11:05.881, value=20
- info:name timestamp=2024-03-21T01:04:05.318, value=Mike
- score:Chinese timestamp=2024-03-21T01:16:34.006, value=90
- score:Math timestamp=2024-03-21T01:16:48.854, value=85
- 1 row(s)
- Took 0.1583 seconds
查询行键为s001，数据列为socre:Chinese的单元格值。
- hbase:103:0> get 'students','s001','score:Chinese'
- COLUMN CELL
- score:Chinese timestamp=2024-03-21T01:16:34.006, value=90
- 1 row(s)
- Took 0.0142 seconds
查询学生Mike的多次数学成绩。（确保score列族数学的VERSION版本不止为1）
- hbase:108:0> alter 'students',NAME=>'score',VERSIONS=>5
- Updating all regions with the new schema...
- 1/1 regions updated.
- Done.
- Took 3.6026 seconds
1）写入学生Mike的多次数学成绩
- hbase:100:0> put 'students','s001','score:Math','92'
- Took 0.0871 seconds
- hbase:101:0> put 'students','s001','score:Math','100'
- Took 0.0158 seconds
2）读取学生Mike最新的一次数学成绩(get命令默认只读出最新写入的单元格值，时间戳版本最大的单元格值内容)。
- hbase:102:0> get 'students','s001','score:Math'
- COLUMN CELL
- score:Math timestamp=2024-03-21T01:23:13.668, value=100
- 1 row(s)
- Took 0.0771 seconds
3）查询学生Mike的3次数学成绩。
- hbase:111:0> get 'students','s001',{COLUMN=>'score:Math',VERSIONS=>3}
- COLUMN CELL
- score:Math timestamp=2024-03-21T01:32:55.629, value=85
- score:Math timestamp=2024-03-21T01:32:35.808, value=92
- score:Math timestamp=2024-03-21T01:23:13.668, value=100
- 1 row(s)
- Took 0.2027 seconds
（3）scan：扫描数据（读取所有行的每个列族的所有数据列的最新时间戳版本的单元格值）
1）为了获得更好效果，现在students表中写入多行数据。
- hbase:112:0> put 'students','s002','info:name','Tom'
- hbase:113:0> put 'students','s002','info:age','19'
- hbase:114:0> put 'students','s002','score:Chinese','87'
- hbase:115:0> put 'students','s002','score:Math','70'
- hbase:116:0> put 'students','s003','info:name','Lucy'
- hbase:117:0> put 'students','s003','info:age',18'
- hbase:122:0> put 'students','s003','score:Chinese','80'
- hbase:123:0> put 'students','s003','score:Math','90'
2）对数据表students进行全表扫描。
- hbase:124:0> scan 'students'
- ROW COLUMN+CELL
- s001 column=info:age, timestamp=2024-03-21T01:11:05.881, value=20
- s001 column=info:name, timestamp=2024-03-21T01:04:05.318, value=Mike
- s001 column=score:Chines, timestamp=2024-03-21T01:16:34.006, value=90
- s001 column=score:Math, timestamp=2024-03-21T01:32:55.629, value=85
- s002 column=info:Chinese, timestamp=2024-03-21T01:43:05.067, value=89
- s002 column=info:Math, timestamp=2024-03-21T01:43:22.209, value=95
- s002 column=info:age, timestamp=2024-03-21T01:42:45.619, value=19
- s002 column=info:name, timestamp=2024-03-21T01:42:33.917, value=Tom
- s003 column=info:age, timestamp=2024-03-21T01:44:16.318, value=18
- s003 column=info:name, timestamp=2024-03-21T01:43:45.397, value=Lucy
- s003 column=score:Chinese, timestamp=2024-03-21T01:45:40.078, value=80
- s003 column=score:Math, timestamp=2024-03-21T01:45:53.743, value=90
- 3 row(s)
- Took 0.2514 seconds
3）对数据表students的指定行键范围的数据进行扫描。
- #若只指定开始的行键STARTROW，会一直扫描到最后，包含STARTROW和最后一行数据
- hbase:135:0> scan 'students',{STARTROW=>'s002'}
- ROW COLUMN+CELL
- s002 column=info:age, timestamp=2024-03-21T01:42:45.619, value=19
- s002 column=info:name, timestamp=2024-03-21T01:42:33.917, value=Tom
- s002 column=score:Chinese, timestamp=2024-03-21T01:48:44.123, value=87
- s002 column=score:Math, timestamp=2024-03-21T01:48:59.578, value=70
- s003 column=info:age, timestamp=2024-03-21T01:44:16.318, value=18
- s003 column=info:name, timestamp=2024-03-21T01:43:45.397, value=Lucy
- s003 column=score:Chinese, timestamp=2024-03-21T01:45:40.078, value=80
- s003 column=score:Math, timestamp=2024-03-21T01:45:53.743, value=90
- 2 row(s)
- Took 0.6646 seconds
- #同时指定STARTROW和STOPROW,行键范围包括STARTROW，但不包含STOPROW的数据
- hbase:136:0> scan 'students',{STARTROW=>'s002',STOPROW=>'s003'}
- ROW COLUMN+CELL
- s002 column=info:age, timestamp=2024-03-21T01:42:45.619, value=19
- s002 column=info:name, timestamp=2024-03-21T01:42:33.917, value=Tom
- s002 column=score:Chinese, timestamp=2024-03-21T01:48:44.123, value=87
- s002 column=score:Math, timestamp=2024-03-21T01:48:59.578, value=70
- 1 row(s)
- Took 0.0566 seconds
4）对数据表students的指定列族info进行扫描。
- hbase:137:0> scan 'students',{COLUMNS=>['info']}
- ROW COLUMN+CELL
- s001 column=info:age, timestamp=2024-03-21T01:11:05.881, value=20
- s001 column=info:name, timestamp=2024-03-21T01:04:05.318, value=Mike
- s002 column=info:age, timestamp=2024-03-21T01:42:45.619, value=19
- s002 column=info:name, timestamp=2024-03-21T01:42:33.917, value=Tom
- s003 column=info:age, timestamp=2024-03-21T01:44:16.318, value=18
- s003 column=info:name, timestamp=2024-03-21T01:43:45.397, value=Lucy
- 3 row(s)
- Took 0.2538 seconds
5）对数据表students的指定列族info下的name数据列进行扫描。
- hbase:138:0> scan 'students',{COLUMNS=>['info:name']}
- ROW COLUMN+CELL
- s001 column=info:name, timestamp=2024-03-21T01:04:05.318, value=Mike
- s002 column=info:name, timestamp=2024-03-21T01:42:33.917, value=Tom
- s003 column=info:name, timestamp=2024-03-21T01:43:45.397, value=Lucy
- 3 row(s)
- Took 0.0447 seconds
6）对数据表students的前2行数据进行扫描。
- hbase:139:0> scan 'students',{LIMIT=>2}
- ROW COLUMN+CELL
- s001 column=info:age, timestamp=2024-03-21T01:11:05.881, value=20
- s001 column=info:name, timestamp=2024-03-21T01:04:05.318, value=Mike
- s001 column=score:Chinese, timestamp=2024-03-21T01:16:34.006, value=90
- s001 column=score:Math, timestamp=2024-03-21T01:32:55.629, value=85
- s002 column=info:age, timestamp=2024-03-21T01:42:45.619, value=19
- s002 column=info:name, timestamp=2024-03-21T01:42:33.917, value=Tom
- s002 column=score:Chinese, timestamp=2024-03-21T01:48:44.123, value=87
- s002 column=score:Math, timestamp=2024-03-21T01:48:59.578, value=70
- 2 row(s)
- Took 0.0328 seconds
（4）count：统计表行数
- hbase:141:0> count 'students'
- 3 row(s)
- Took 1.1445 seconds
- => 3
（5）delete：删除指定数据列单元格
删除数据表students的指定数据列单元格（删除行键003的列族score下的列限定符Math单元格）。
- hbase:143:0> delete 'students','s003','score:Math'
- Took 0.0677 seconds
- hbase:144:0> get 'students','s003'
- COLUMN CELL
- info:age timestamp=2024-03-21T01:44:16.318, value=18
- info:name timestamp=2024-03-21T01:43:45.397, value=Lucy
- score:Chines timestamp=2024-03-21T01:45:40.078, value=80
- 1 row(s)
- Took 0.1472 seconds
（6）deleteall：删除指定数据行
1）删除数据表students的行键为s003的数据。
- hbase:145:0> deleteall 'students','s003'
- Took 0.1017 seconds
- hbase:146:0> get 'students','s003'
- COLUMN CELL
- 0 row(s)
- Took 0.0270 seconds
2）删除数据表students的行键为s002，列名为score:chinese的所有数据。
- hbase:148:0> deleteall 'students','s002','score:Chinese'
- Took 0.0182 seconds
- hbase:149:0> get 'students','s002'
- COLUMN CELL
- info:age timestamp=2024-03-21T01:42:45.619, value=19
- info:name timestamp=2024-03-21T01:42:33.917, value=Tom
- score:Math timestamp=2024-03-21T01:48:59.578, value=70
- 1 row(s)
- Took 0.0348 seconds
（7）append：给指定列的单元格追加内容
给行键s002，列名info: name的数据列单元格值Tom后面追加son后变成Tomson。
- hbase:007:0> append 'students','s002','info:name','son'
- CURRENT VALUE = Tomson
- Took 0.9325 seconds
- hbase:008:0> get 'students','s002'
- COLUMN CELL
- info:age timestamp=2024-03-21T01:42:45.619, value=19
- info:name timestamp=2024-03-21T06:16:33.838, value=Tomson
- score:Math timestamp=2024-03-21T01:48:59.578, value=70
- 1 row(s)
- Took 0.4914 seconds
（8）truncate：清空指定数据表的全部数据内容
清空数据表students的内容。
- hbase:009:0> truncate 'students'
- Truncating 'students' table (it may take a while):
- Disabling table...
- 2024-03-21 06:17:52,730 INFO [main] client.HBaseAdmin (HBaseAdmin.java:rpcCall(926)) - Started disable of students
- 2024-03-21 06:17:57,843 INFO [main] client.HBaseAdmin (HBaseAdmin.java:postOperationResult(3591)) - Operation: DISABLE, Table Name: default:students, procId: 194 completed
- Truncating table...
- 2024-03-21 06:17:57,898 INFO [main] client.HBaseAdmin (HBaseAdmin.java:rpcCall(806)) - Started truncating students
- 2024-03-21 06:18:02,439 INFO [main] client.HBaseAdmin (HBaseAdmin.java:postOperationResult(3591)) - Operation: TRUNCATE, Table Name: default:students, procId: 197 completed
- Took 10.4274 seconds
- hbase:010:0> scan 'students'
- ROW COLUMN+CELL
- 0 row(s)
- Took 6.5341 seconds
六、查询数据时显示中文内容
直接通过设置FORMATTER的属性值为'toString'即可。
- hbase:022:0> scan 'major',FORMATTER=>'toString'
- ROW COLUMN+CELL
- row1 column=info:college, timestamp=2024-04-08T04:50:16.954, value=信息工程学院
- row1 column=info:mname, timestamp=2024-04-08T04:49:59.301, value=大数据技术
- row1 column=info:mnum, timestamp=2024-04-08T04:49:29.291, value=m001
- row1 column=other:class, timestamp=2024-04-08T04:50:40.604, value=engineer
- row2 column=info:college, timestamp=2024-04-08T04:52:15.739, value=信息工程学院
- row2 column=info:mname, timestamp=2024-04-08T04:52:10.160, value=网络技术
- row2 column=info:mnum, timestamp=2024-04-08T04:52:03.393, value=m002
- row2 column=other:class, timestamp=2024-04-08T04:52:23.712, value=engineer
- 2 row(s)
- Took 0.0779 seconds
声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/笔触狂放9/article/detail/633815
推荐阅读
相关标签
