hive存储元数据在mysql配置

最新推荐文章于 2024-07-21 16:34:38 发布

键盘上的孤舞者

最新推荐文章于 2024-07-21 16:34:38 发布

阅读量888

点赞数

分类专栏： hive 文章标签： hive

本文链接：https://blog.csdn.net/king_sky_wjb/article/details/31739457

版权

hive 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

1. hive运行在hadoop，首先得确保hadoop运行

2. 下载hive

3. 下在mysql驱动，放在hive的lib目录

4. 配置文件：在hive/conf下新建hive-site.xml文件，修改其中的：

<!--derby-->
<!--
<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:derby:;databaseName=metastore_db;create=true</value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>org.apache.derby.jdbc.EmbeddedDriver</value>
  <description>Driver class name for a JDBC metastore</description>
</property>

<property>
  <name>javax.jdo.PersistenceManagerFactoryClass</name>
  <value>org.datanucleus.api.jdo.JDOPersistenceManagerFactory</value>
  <description>class implementing the jdo persistence</description>
</property>

<property>
  <name>javax.jdo.option.DetachAllOnCommit</name>
  <value>true</value>
  <description>detaches all objects from session so that they can be used after transaction is committed</description>
</property>

<property>
  <name>javax.jdo.option.NonTransactionalRead</name>
  <value>true</value>
  <description>reads outside of transactions</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>APP</value>
  <description>username to use against metastore database</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>mine</value>
  <description>password to use against metastore database</description>
</property>

<property>
  <name>javax.jdo.option.Multithreaded</name>
  <value>true</value>
  <description>Set this to true if multiple threads access metastore through JDO concurrently.</description>
</property>

-->

修改为：

<!--mysql-->

 <property>
   <name>javax.jdo.option.ConnectionURL</name>
   <value>jdbc:mysql://localhost:3306/hiveMeta?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.PersistenceManagerFactoryClass</name>
   <value>org.datanucleus.api.jdo.JDOPersistenceManagerFactory</value>
   <description>class implementing the jdo persistence</description>
 </property>

 <property>
   <name>javax.jdo.option.DetachAllOnCommit</name>
   <value>true</value>
   <description>detaches all objects from session so that they can be used after transaction is committed</description>
 </property>

 <property>
   <name>javax.jdo.option.NonTransactionalRead</name>
   <value>true</value>
   <description>reads outside of transactions</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>wjb1234</value>
   <description>password to use against metastore database</description>
 </property>


 <property>
   <name>javax.jdo.option.Multithreaded</name>
   <value>true</value>
   <description>Set this to true if multiple threads access metastore through JDO concurrently.</description>
 </property>

5. 运行./bin/hive即可

6. 示例：

show tables;

CREATE TABLE pokes (foo INT, bar STRING);

LOAD DATA LOCAL INPATH './examples/files/kv1.txt' OVERWRITE INTO TABLE pokes;

  > select * from pokes;
OK
238	val_238
86	val_86
311	val_311
。。。

90	val_90
169	val_169
403	val_403
400	val_400
200	val_200
97	val_97
Time taken: 0.092 seconds, Fetched: 500 row(s)