mysql+hive

1.zjgm01 zjgm02 zjgm03 “./zkServer.sh start”
2.zjgm01 “start-dfs.sh”
3.zjgm03 “start-yarn.sh”
页面结果如下


将“zjgm02”的namenode使用“kill -9”语句

“zjgm01”网页结果

将“hive-0.12.0.tar.gz”上传到根目录
将“hive-0.12.0.tar.gz”解压到app下

进入“/home/hadoop/app/hive-0.12.0/lib”路径下，“alt+p”使用“cd /home/hadoop/app/hive-0.12.0/lib”语句后将“mysql-connector-java-5.1.28.jar”文件拖入到该目录下

进入“/home/hadoop/app/hive-0.12.0/bin”路径下–“./hive”语句启动

“show databases;”查询

建表

create table t_xyb(id int,name String,price double)
 row format delimited
 fields terminated by '\t';

使用“show tables;”查看

查询是否有旧的mysql–“rpm -qa|grep mysql”

删除旧版本–“sudo rpm -e mysql-libs-5.1.66-2.el6_3.i686 --nodeps”

安装mysql
“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”

修改密码–“mysqladmin -u root password ‘root’”

登入mysql–“mysql -u root -p”

授权
“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;”

数据库创建新连接

结果如下图

进入“/home/hadoop/app/hive-0.12.0/conf”路径下
写“hive-site.xml”文件

内容如下

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements.  See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License.  You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
-->
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hivedb?createDatabaseIfNotExist=true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>root</value>
</property>
</configuration>

进入“/home/hadoop/app/hive-0.12.0/bin”下，“./hive”启动
重新建一次表

打开数据库刷新，可看到新增的“TBLS”表内容如下