HBase Shell操作、HBase创建表、添加数据、查看表数据、操作列簇、删除表 05

深藏阁楼爱情的钟 2022-02-16 00:23 620阅读 0赞

# 1. HBase Shell操作连接集群 #

hbase shell

# 2. 创建表 #

create 'user','base_info'

# 3. 向表中添加数据 #

put 'user', 'rowkey_10', 'base_info:username', '张三'
    put 'user', 'rowkey_10', 'base_info:birthday', '2014-07-10'
    put 'user','rowkey_10','base_info:sex','1'
    put 'user','rowkey_10','base_info:address','北京市'
    
    put 'user','rowkey_16','base_info:username','张小明'
    put 'user','rowkey_16','base_info:birthday','2014-07-10'
    put 'user','rowkey_16','base_info:sex','1'
    put 'user','rowkey_16','base_info:address','北京'
    
    put 'user','rowkey_22','base_info:username','陈小明'
    put 'user','rowkey_22','base_info:birthday','2014-07-10'
    put 'user','rowkey_22','base_info:sex','1'
    put 'user','rowkey_22','base_info:address','上海'
    
    put 'user','rowkey_24','base_info:username','张三丰'
    put 'user','rowkey_24','base_info:birthday','2014-07-10'
    put 'user','rowkey_24','base_info:sex','1'
    put 'user','rowkey_24','base_info:address','河南'
    
    put 'user','rowkey_25','base_info:username','陈大明'
    put 'user','rowkey_25','base_info:birthday','2014-07-10'
    put 'user','rowkey_25','base_info:sex','1'
    put 'user','rowkey_25','base_info:address','西安'

# 4. 查询表中的所有数据 #

scan 'user'

# 5. 查询某个rowkey的数据 #

get 'user', 'rowkey_16'

# 6. 查询某个列簇的数据 #

get 'user', 'rowkey_16', 'base_info'
    get 'user', 'rowkey_16', 'base_info:username'
    get 'user', 'rowkey_16', { COLUMN => ['base_info:username', 'base_info:sex']}

# 7. 删除表中的数据 #

delete 'user', 'rowkey_16', 'base_info:username'

# 8. 清空数据 #

truncate 'user'

# 9. 操作列簇 #

alter 'user'， NAME => 'f2'
    alter 'user', 'delete' => 'f2'

# 10. 删除表 #

**一定要先disable 表， 然后才能删除表**

disable 'user'
    drop 'user'

# 11. HBase命令表 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY0MTkwOQ_size_16_color_FFFFFF_t_70]  
可以通过HBaseUI界面查看表的信息  
端口60010打不开的情况，是因为HBase 1.0以后的版本，需要自己手动配置，在文件hbase-site

<property>  
    	<name>hbase.master.info.port</name>  
    	<value>60010</value>  
    </property>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjY0MTkwOQ_size_16_color_FFFFFF_t_70]: /images/20220216/c894f05ff64d4e398b66f71b3e0bd4f4.png