一、操作HBase常用Shell命令(参考教材4.6.1或后面的华为云实验)创建学生信息表并添加数据(列数不少于5个,数据记录不少于10条),数据表名字是自己姓名全拼,表数据有自己的姓名:
安装 Hbase
首先确认是否安装Hadoop,关闭顺序与启动顺序相反:先关闭HBase,之后再关闭Hadoop。
1.下载安装包:
wget --no-check-certificate https://mirrors.tuna.tsinghua.edu.cn/apache/hbase/2.4.17/hbase-2.4.17-bin.tar.gz
2.解压安装包:
tar -zxvf hbase-2.4.17-bin.tar.gz -C /opt/
3.更改文件名:
mv /opt/hbase-2.4.17 /opt/hbase
4.配置环境变量:
echo 'export HBASE_HOME=/opt/hbase/' >> /etc/profile
echo 'export PATH=$PATH:$HBASE_HOME/bin' >> /etc/profile
source /etc/profile
5.修改配置文件:
echo "export JAVA_HOME=/usr/java8" >> /opt/hbase/conf/hbase-env.sh
echo " HBASE_CLASSPATH=/opt/hbase/conf " >> /opt/hbase/conf/hbase-env.sh
echo " HBASE_MANAGES_ZK=true " >> /opt/hbase/conf/hbase-env.sh
修改 hbase-site.xml 文件
vim /opt/hbase/conf/hbase-site.xml
增加下面的代码:
<property>
<name>hbase.rootdir</name>
<value>hdfs://localhost:9000/hbase</value>
</property>
<property>
<name>hbase.cluster.distributed</name>
<value>true</value>
</property>
6.启动HBase(先启动Hadoop):
start-hbase.sh
7.检查JPS含有 HMaster、HRegionServer、HQuorumPeer 进程。
8.访问Web页面,http://公网IP:16010, 需要放行 16919 端口
9.进行HBase数据操作:
hbase shell
10.建立数据表:
create 'brisy', 'name', 'email', 'gender', 'student_id', 'major'
11.插入数据:
put 'brisy', '1', 'name:', 'Brisy'.to_java_bytes
put 'brisy', '1', 'email:', 'brisy@example.com'.to_java_bytes
put 'brisy', '1', 'gender:', '男'.to_java_bytes
put 'brisy', '1', 'student_id:', '1024001'.to_java_bytes
put 'brisy', '1', 'major:', '计算机科学与技术'.to_java_bytes
put 'brisy', '2', 'name:', 'Ann'.to_java_bytes
put 'brisy', '2', 'email:', 'Ann@example.com'.to_java_bytes
put 'brisy', '2', 'gender:', '女'.to_java_bytes
put 'brisy', '2', 'student_id:', '102402'.to_java_bytes
put 'brisy', '2', 'major:', '计算机科学与技术'.to_java_bytes
put 'brisy', '3', 'name:', 'Tom'.to_java_bytes
put 'brisy', '3', 'email:', 'Tom@example.com'.to_java_bytes
put 'brisy', '3', 'gender:', '男'.to_java_bytes
put 'brisy', '3', 'student_id:', '102402'.to_java_bytes
put 'brisy', '3', 'major:', '计算机科学与技术'.to_java_bytes
put 'brisy', '4', 'name:', 'jessie'.to_java_bytes
put 'brisy', '4', 'email:', 'jessie@example.com'.to_java_bytes
put 'brisy', '4', 'gender:', '女'.to_java_bytes
put 'brisy', '4', 'student_id:', '102403'.to_java_bytes
put 'brisy', '4', 'major:', '计算机科学与技术'.to_java_bytes
put 'brisy', '5', 'name:', 'kangkang'.to_java_bytes
put 'brisy', '5', 'email:', 'kangkang@example.com'.to_java_bytes
put 'brisy', '5', 'gender:', '男'.to_java_bytes
put 'brisy', '5', 'student_id:', '102404'.to_java_bytes
put 'brisy', '5', 'major:', '计算机科学与技术'.to_java_bytes
put 'brisy', '6', 'name:', 'moria'.to_java_bytes
put 'brisy', '6', 'email:', 'moria@example.com'.to_java_bytes
put 'brisy', '6', 'gender:', '女'.to_java_bytes
put 'brisy', '6', 'student_id:', '102405'.to_java_bytes
put 'brisy', '6', 'major:', '软件工程'.to_java_bytes
put 'brisy', '7', 'name:', 'jane'.to_java_bytes
put 'brisy', '7', 'email:', 'jane@example.com'.to_java_bytes
put 'brisy', '7', 'gender:', '女'.to_java_bytes
put 'brisy', '7', 'student_id:', '102406'.to_java_bytes
put 'brisy', '7', 'major:', '大数据技术'.to_java_bytes
put 'brisy', '8', 'name:', 'micle'.to_java_bytes
put 'brisy', '8', 'email:', 'micle@example.com'.to_java_bytes
put 'brisy', '8', 'gender:', '男'.to_java_bytes
put 'brisy', '8', 'student_id:', '102407'.to_java_bytes
put 'brisy', '8', 'major:', '计算机科学与技术'.to_java_bytes
put 'brisy', '9', 'name:', 'may'.to_java_bytes
put 'brisy', '9', 'email:', 'may@example.com'.to_java_bytes
put 'brisy', '9', 'gender:', '男'.to_java_bytes
put 'brisy', '9', 'student_id:', '102408'.to_java_bytes
put 'brisy', '9', 'major:', '大数据技术'.to_java_bytes
put 'brisy', '10', 'name:', 'fei'.to_java_bytes
put 'brisy', '10', 'email:', 'fei@example.com'.to_java_bytes
put 'brisy', '10', 'gender:', '男'.to_java_bytes
put 'brisy', '10', 'student_id:', '102409'.to_java_bytes
put 'brisy', '10', 'major:', '计算机网络'.to_java_bytes
put 'brisy', '11', 'name:', 'merit'.to_java_bytes
put 'brisy', '11', 'email:', 'merit@example.com'.to_java_bytes
put 'brisy', '11', 'gender:', '男'.to_java_bytes
put 'brisy', '11', 'student_id:', '1024010'.to_java_bytes
put 'brisy', '11', 'major:', '计算机科学与技术'.to_java_bytes
put 'brisy', '12', 'name:', 'dai'.to_java_bytes
put 'brisy', '12', 'email:', 'dai@example.com'.to_java_bytes
put 'brisy', '12', 'gender:', '男'.to_java_bytes
put 'brisy', '12', 'student_id:', '1024011'.to_java_bytes
put 'brisy', '12', 'major:', '计算机网络'.to_java_bytes
12.查看表:
scan 'brisy',{FORMATTER=>'toString'}
结果如下:
HBase 指令补充:
// 删除数据表
disable 'brisy'
drop 'brisy'
// 退出HBase
exit