【HBase】 常用命令
2024-09-07 15:09:43
创建表
hbase(main):006:0> create 'goods_zc','type'
0 row(s) in 1.3090 seconds
=> Hbase::Table - goods_zc
删除表
hbase(main):008:0> disable 'goods_zc'
0 row(s) in 2.4100 seconds
hbase(main):009:0> drop 'goods_zc'
0 row(s) in 1.2780 seconds
添加数据
hbase(main):014:0> put 'goods_zc','1001','info:type','fruit'
0 row(s) in 0.0370 seconds
hbase(main):015:0> put 'goods_zc','1001','info:discount','0.8'
0 row(s) in 0.0250 seconds
hbase(main):016:0> put 'goods_zc','1001','address:where','wuhan'
0 row(s) in 0.0360 seconds
hbase(main):017:0> put 'goods_zc','1001','info:name','banana'
0 row(s) in 0.0150 seconds
hbase(main):018:0> put 'goods_zc','1003','info:name','carrot'
0 row(s) in 0.0280 seconds
hbase(main):019:0> put 'goods_zc','1003','info:type','vegetable'
0 row(s) in 0.0270 seconds
hbase(main):020:0> put 'goods_zc','1003','info:kind','high-quality'
0 row(s) in 0.0140 seconds
hbase(main):021:0> put 'goods_zc','1003','info:discount','2'
0 row(s) in 0.0320 seconds
hbase(main):022:0> put 'goods_zc','1006','info:name','bear'
0 row(s) in 0.0220 seconds
hbase(main):023:0> put 'goods_zc','1006','info:price','25'
0 row(s) in 0.0130 seconds
hbase(main):024:0> put 'goods_zc','1006','info:object','5'
0 row(s) in 0.0180 seconds
hbase(main):025:0> put 'goods_zc','1006','info:material','cotton'
0 row(s) in 0.0210 seconds
hbase(main):026:0> put 'goods_zc','1002','info:name','cat'
0 row(s) in 0.0390 seconds
hbase(main):027:0> put 'goods_zc','1004','info:name','fmvp'
0 row(s) in 0.0160 seconds
hbase(main):028:0> put 'goods_zc','1005','info:name','hero'
0 row(s) in 0.0280 seconds
hbase(main):029:0> put 'goods_zc','1007','info:name','ag'
0 row(s) in 0.0150 seconds
hbase(main):030:0> put 'goods_zc','1008','info:name','rgm'
0 row(s) in 0.0170 seconds
hbase(main):031:0> put 'goods_zc','1009','info:name','qghappy'
0 row(s) in 0.0140 seconds
hbase(main):032:0> put 'goods_zc','1010','info:name','中文测试'
0 row(s) in 0.0190 seconds
查看全表
hbase(main):033:0> scan 'goods_zc'
ROW COLUMN+CELL
1001 column=address:where, timestamp=1570790847160, value=wuhan
1001 column=info:discount, timestamp=1570790813784, value=0.8
1001 column=info:name, timestamp=1570790933889, value=banana
1001 column=info:type, timestamp=1570790756853, value=fruit
1002 column=info:name, timestamp=1570791810946, value=cat
1003 column=info:discount, timestamp=1570791425426, value=2
1003 column=info:kind, timestamp=1570791409436, value=high-quality
1003 column=info:name, timestamp=1570791369714, value=carrot
1003 column=info:type, timestamp=1570791382735, value=vegetable
1004 column=info:name, timestamp=1570791822468, value=fmvp
1005 column=info:name, timestamp=1570791838620, value=hero
1006 column=info:material, timestamp=1570791478499, value=cotton
1006 column=info:name, timestamp=1570791438023, value=bear
1006 column=info:object, timestamp=1570791465164, value=5
1006 column=info:price, timestamp=1570791451505, value=25
1007 column=info:name, timestamp=1570791847743, value=ag
1008 column=info:name, timestamp=1570791857292, value=rgm
1009 column=info:name, timestamp=1570791868258, value=qghappy
1010 column=info:name, timestamp=1570791877643, value=\xE4\xB8\xAD\xE6\x96\x87\xE6\xB5\x8B\xE8\xAF\x95
10 row(s) in 0.0710 seconds
变量
hbase(main):045:0> t=get_table 'goods_zc'
0 row(s) in 0.0000 seconds
=> Hbase::Table - goods_zc
hbase(main):046:0> t.get '1001'
COLUMN CELL
address:where timestamp=1570790847160, value=wuhan
info:discount timestamp=1570792094524, value=8.5
info:name timestamp=1570790933889, value=banana
info:type timestamp=1570790756853, value=fruit
4 row(s) in 0.0210 seconds
条件查看
hbase(main):050:0> scan 'goods_zc',{LIMIT=>3,STARTROW=>'1006'}
ROW COLUMN+CELL
1006 column=info:material, timestamp=1570791478499, value=cotton
1006 column=info:name, timestamp=1570791438023, value=bear
1006 column=info:object, timestamp=1570791465164, value=5
1006 column=info:price, timestamp=1570791451505, value=25
1007 column=info:name, timestamp=1570791847743, value=ag
1008 column=info:name, timestamp=1570791857292, value=rgm
3 row(s) in 0.0340 seconds
最新文章
- Openstack Basic
- 浅析WPhone、Android的Back与Home键
- [自制简单操作系统] 1、从0-1到汇编再到c语言的奥秘
- 外包采用Gradle生成多套app打包
- 【M14】明智运用异常规范
- MySQL基础操作命令
- iOS9 升级设置
- hibernate与spring整合实现transaction
- 基于ARM_contexA9 led驱动编程
- VSCode的Python扩展下程序运行的几种方式与环境变量管理
- 向后台提交数据：通过form表单提交数据需刷新网页 但通过Ajax提交数据不用刷新网页可通过原生态Ajax或jqueryAjax。Ajax代码部分
- 删除文件夹下各级子目录中的.svn文件
- nohup后台执行
- Docker run 出现问题如何调试？
- Linux服务器上新增开放端口号
- mosquitto 配置文件解说
- KVM虚拟机的xml配置文件
- FasterRCNN目标检测实践纪实
- ThinkPHP出现项目目录不可写，目录无法自动生成
- 文本检测： CTPN