本系列所用到的安裝包部落客已經上傳到百度雲盤中,如有需要的可以自取。下面為連結:
連結:https://pan.baidu.com/s/10ezDJTuZl-qU2sq0hDCinw
提取碼:pw12
目錄
- 一. 驅動拷貝
-
- 1.在/opt/software/mysql-libs目錄下解壓mysql-connector-java-5.1.27.tar.gz驅動包
- 2.拷貝/opt/software/mysql-libs/mysql-connector-java-5.1.27目錄下的mysql-connector-java-5.1.27-bin.jar到/opt/module/hive/lib/
- 二. 配置Metastore到MySql
-
- 2.1 在/opt/module/hive/conf目錄下建立一個hive-site.xml
- 2.2 根據官方文檔配置參數,拷貝資料到hive-site.xml檔案中
- 2.3 測試啟動
- 三. 多視窗啟動Hive測試
-
- 3.1 先啟動MySQL
- 3.2 再次打開多個視窗,啟動hive
- 3.3 啟動hive後,回到MySQL視窗檢視資料庫,顯示增加了`metastore資料庫`
[root@hadoop001 mysql-libs]# tar -zxvf mysql-connector-java-5.1.27.tar.gz
[root@hadoop001 mysql-connector-java-5.1.27]# cp mysql-connector-java-5.1.27-bin.jar /opt/module/hive/lib/
在 這 個 時 候 就 可 以 轉 換 成 h a d o o p 用 戶 了 \color{#FF0000}{在這個時候就可以轉換成hadoop使用者了} 在這個時候就可以轉換成hadoop使用者了
[bigdata@hadoop001 mysql-connector-java-5.1.27]$ cd /opt/module/hive/conf
[bigdata@hadoop001 conf]$ vim hive-site.xml
https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://hadoop001:3306/metastore?createDatabaseIfNotExist=true</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>199712</value>
<description>password to use against metastore database</description>
</property>
</configuration>
![](https://img.laitimes.com/img/9ZDMuAjOiMmIsIjOiQnIsISPrdEZwZ1Rh5WNXp1bwNjW1ZUba9VZwlHdsATOfd3bkFGazxCMx8VesATMfhHLlN3XnxCMwEzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5iZ0ATMyADOyMGOjFWMmljZjFDMzIWYzUDN4IWZxcTMj9CXyAzLclDMxIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjL4M3Lc9CX6MHc0RHaiojIsJye.png)
配置完畢後,如果啟動hive異常,可以重新啟動虛拟機。(重新開機後,别忘了啟動hadoop叢集)
[bigdata@hadoop001 hive]$ bin/hive
[bigdata@hadoop001 mysql-libs]$ mysql -uroot -p199712
# 檢視有幾個資料庫
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
[bigdata@hadoop001 hive]$ bin/hive
3.3 啟動hive後,回到MySQL視窗檢視資料庫,顯示增加了 metastore資料庫
metastore資料庫
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| metastore |
| mysql |
| performance_schema |
| test |
+--------------------+