11.启动zookeeper集群(分别在zjgm01、zjgm02、zjgm03上启动zk)
cd /home/hadoop/app/zookeeper-3.4.5/bin
./zkServer.sh start
#查看状态:一个leader,两个follower
./zkServer.sh status
启动昨天的启动HDFS(在zjgm01上执行)
sbin/start-dfs.sh
启动YARN(#####注意#####:是在zjgm03上执行start-yarn.sh)
sbin/start-yarn.sh
然后再kill掉active的NameNode
kill -9 <pid of NN>
通过浏览器访问:http://192.168.2.102:50070
NameNode 'zjgm01:9000' (active)
这个时候zjgm02上的NameNode变成了active
通过浏览器访问:http://192.168.2.102:50070
NameNode 'zjgm021:9000' (standby)
1.2zjgm02 kill -9
2.1 上传 hive-0.12.0.tar.gz 并解压到app/
cd /home/hadoop
put C:\Users\19668\Desktop\2\hive-0.12.0.tar.gz
解压 tar -zxvf hive-0.12.0.tar.gz -C app/
在cd /home/hadoop/app/hive-0.12.0/lib路径下上传mysql-connector-java-5.1.28.jar
sftp> cd /home/hadoop/app/hive-0.12.0/lib
sftp> put C:\Users\19668\Desktop\2\mysql-connector-java-5.1.28.jar
cd…
cd bin
show databases; //查看数据库
show tables;//查看表
创建表
create table t_xyb(id int,name String,price double)
row format delimited
fields terminated by ‘\t’;
exit; //退出
上传mysql
cd /home/hadoop
sftp> put C:\Users\19668\Desktop\2\MySQL-client-5.1.73-1.glibc23.i386.rpm
sftp> put C:\Users\19668\Desktop\2\MySQL-server-5.1.73-1.glibc23.i386.rpm
1.上传成功
2.检查是否安装过mysql
rpm -qa|grep mysql
rpm -qa | grep -i mysql
3.如果有删除mysql 在检查一下
sudo rpm -e ×××× --nodeps
sudo r sudo rpm -e mysql-libs-5.1.66-2.el6_3.i686 --nodeps
4.安装
sudo rpm -ivh /home/hadoop/MySQL-server-5.1.73-1.glibc23.i386.rpm
sudo rpm -ivh /home/hadoop/MySQL-client-5.1.73-1.glibc23.i386.rpm
5.修改密码
mysqladmin -u root password ‘root’
6.登入mysql 查询表
mysql -u root -p
7. 授权 才可以建立连接
grant all privileges on . to root@"%" identified by “root” with grant option;
grant all privileges on . to root@“localhost” identified by “root” with grant option;
FLUSH PRIVILEGES;
exit;退出
打开本地电脑的mysql 建立新连接 密码root
8.在/home/hadoop/app/hive-0.12.0/conf下
新建 vi hive-site.xml
添加
9.在/home/hadoop/app/hive-0.12.0
cd bin
./hive
查询数据库
show databases;
create table t_xyb(id int,name String,price double)
row format delimited
fields terminated by ‘\t’;
打开数据库成功