CentOS7下Hive 安装过程

前提：在Linux上安装mysql，并创建远程账号 https://blog.csdn.net/ruthywei/article/details/79747559

版本：

hive-1.2.2: https://pan.baidu.com/s/1l1l2aGNqgGV4zJHlfZhYNQ

mysql5.7:  https://pan.baidu.com/s/1xfwETzopdJE14E4q0SSxDQ

1.在hive-1.2.2/conf下新建文件hive-site.xml

[root@master conf] vi hive-site.xml

<configuration>

<property>

<name>javax.jdo.option.ConnectionURL</name>

<value>jdbc:mysql://master:3306/hive? createDatabaseIfNotExist=true</value>

<description>JDBC coonect 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>123456Whh!</value>

<description>password to use against metastore database</description>

</property>

</configuration>

若出现问题：

Fri Mar 30 16:32:22 EDT 2018 WARN : Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

则修改：

<value>jdbc:mysql://master:3306/hive?useSSL=false</value>

且不可出现&符号，例如

<value>jdbc:mysql://master:3306/hive?useSSL=false&createDatabaseIfNotExist=true</value>

2.修改好运行会报错

Caused by: org.datanucleus.store.rdbms.connectionpool.DatastoreDriverNotFoundException: The specified datastore driver (" com.mysql.jdbc.Driver") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.

at org.datanucleus.store.rdbms.connectionpool.AbstractConnectionPoolFactory.loadDriver(AbstractConnectionPoolFactory.java:58)

at org.datanucleus.store.rdbms.connectionpool.BoneCPConnectionPoolFactory.createConnectionPool(BoneCPConnectionPoolFactory.java:54)

at org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources(ConnectionFactoryImpl.java:238)

... 68 more

3.上传mysql-connection-java-5.1.39.jar（该资源在百度网盘 https://pan.baidu.com/s/1368IeQ4dJerMo2DJq7hcww ）

上传文件mysql-connection-java-5.1.39.jar 到 hadoop-1.2.2/lib/

同理把mysql文件复制到slave1上，slave1可以运行mysql：

[root@master ~]$ scp -r /home/hadoop/local/hive-1.2.2 hadoop@slave1:/home/hadoop/local

[root@slave1 hadoop-1.2.2] $ bin/hive