Ubuntu 安裝hive + mysql

先安裝mysql 

sudo apt-get update
sudo apt-get install mysql-server 
sudo mysql_secure_installation
具體詳情請另查。
註意：mysql 5.7.24 會有安全檢測之類，可能需要降低安全機制：
　　詳見：https://blog.csdn.net/u014236541/article/details/78244601

1. 通過tar -zxvf ....hive.tar.gz  -C /soft  解壓安裝hive

1. 　　進入conf/目錄：
   1. cp hive-default.xml.template hive-default.xml
      1. 　　

             <property>
                 <name>javax.jdo.option.ConnectionURL</name>
                 <value>jdbc:mysql://hadoop-senior01.itguigu.com: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>123456</value>
                 <description>password to use against metastore database</description>
             </property>
             <!-- 是否在當前客戶端中顯示查詢出來的數據的欄位名稱 -->
             <property>
                 <name>hive.cli.print.header</name>
                 <value>true</value>
                 <description>Whether to print the names of the columns in query output.</description>
             </property>
         
             <!-- 是否在當前客戶端中顯示當前所在資料庫名稱 -->
             <property>
                 <name>hive.cli.print.current.db</name>
                 <value>true</value>
                 <description>Whether to include the current database in the Hive prompt.</description>
             </property>

          

   2. cp hive-env.sh.template hive-env.sh
      1. 　　

         # Set HADOOP_HOME to point to a specific hadoop install directory
         HADOOP_HOME=/soft/hadoop-2.5.0-cdh5.3.6
         
         # Hive Configuration Directory can be controlled by:
         export HIVE_CONF_DIR=/soft/hive-0.13.1-cdh5.3.6/conf
         
         # Folder containing extra ibraries required for hive compilation/execution can be controlled by:
         # export HIVE_AUX_JARS_PATH=
         ubantu@s101:/soft/hive-0.13.1-cdh5.3.

         3. cp hive-exec-log4j.properties.template hive-exec-log4j.properties  顯示日誌