hive中怎么設(shè)置外部數(shù)據(jù)倉庫

hive中怎么設(shè)置外部數(shù)據(jù)倉庫，相信很多沒有經(jīng)驗(yàn)的人對此束手無策，為此本文總結(jié)了問題出現(xiàn)的原因和解決方法，通過這篇文章希望你能解決這個問題。

           使用MySQL作為hive的metastore
           1.1 安裝mysql
           1.2 把mysql-connector-java-11.10.jar放到hive的lib目錄下
           1.3 修改hive/conf目錄下的文件hive-site.xml
                <property>
                      <name>javax.jdo.option.ConnectionURL</name>
                      <value>jdbc:mysql://hadoop0:3306/hive?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>admin</value>
                      <description>password to use against metastore database</description>
             </property>

看完上述內(nèi)容，你們掌握hive中怎么設(shè)置外部數(shù)據(jù)倉庫的方法了嗎？如果還想學(xué)到更多技能或想了解更多相關(guān)內(nèi)容，歡迎關(guān)注億速云行業(yè)資訊頻道，感謝各位的閱讀！