1、在windows上先要有一个mysql数据库,我使用的是5.7版本的mysql数据库,5.5的也可以。
2、先启动mysql的服务,再关闭windows的防火墙
3、放开mysql进行外部链接的权限:
1)进入mysql命令行
2)输入:GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
| |
用户名 密码
3)输入:flush privileges;刷新命令。
4、将hadoop中的jline包替换成hive中的jline:
1)cd /opt/wdp/hive/lib
2)cp jline-2.12.jar /opt/wdp/hadoop/share/hadoop/yarn/lib
5、修改hive的配置文件:
1)cd /opt/wdp/hive/conf
2)vi hive-site.xml
3)将如下代码写到hive-site.xml配置文件。
<?xml version="1.0" encoding="UTF-8" standalone="no"?><?xml-stylesheet type="text/xsl" href="configuration.xsl"?><configuration><property><name>hive.metastore.local</name><value>true</value></property><property><name>javax.jdo.option.ConnectionURL</name><value>jdbc:mysql://192.168.24.1:3306/hive?createDatabaseIfNotExist=true&useSSL=false</value><description>JDBC connect string for a JDBC metastore</description></property><property><name>javax.jdo.option.ConnectionDriverName</name><value>com.mysql.jdbc.Driver</value><description>Driver class name for a JDBC metastore</description></property><property><name>javax.jdo.option.ConnectionUserName</name><value>root</value><description>username to use against metastore database</description></property><property><name>javax.jdo.option.ConnectionPassword</name><value>root</value><description>password to use against metastore database</description></property></configuration>
1、将linux上的mysql服务启动:service mysql start。
2、修改hive的配置文件(只需修改ip和mysql密码即可):
1)cd /opt/wdp/hive/conf
2)vi hive-site.xml
3)将如下代码写到hive-site.xml配置文件。
<?xml version="1.0" encoding="UTF-8" standalone="no"?><?xml-stylesheet type="text/xsl" href="configuration.xsl"?><configuration><property><name>hive.metastore.local</name><value>true</value></property><property><name>javax.jdo.option.ConnectionURL</name><value>jdbc:mysql://192.168.24.100:3306/hive?createDatabaseIfNotExist=true&useSSL=false</value><description>JDBC connect string for a JDBC metastore</description></property><property><name>javax.jdo.option.ConnectionDriverName</name><value>com.mysql.jdbc.Driver</value><description>Driver class name for a JDBC metastore</description></property><property><name>javax.jdo.option.ConnectionUserName</name><value>root</value><description>username to use against metastore database</description></property><property><name>javax.jdo.option.ConnectionPassword</name><value>123456</value><description>password to use against metastore database</description></property></configuration>