Hive 配置

最新推荐文章于 2023-07-13 00:25:41 发布

mark_yueye

最新推荐文章于 2023-07-13 00:25:41 发布

阅读量1.1k

点赞数 1

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

本文链接：https://blog.csdn.net/yueyedeai/article/details/14525107

版权

Hive 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

<configuration>
<property>
<name>hive.metastore.local</name>
<value>false</value>
</property>

<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://hadoop23:3306/hive?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=latin1</value>
</property>

<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>

<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hive</value>
</property>

<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hivepwd</value>
</property>

<property>
<name>hive.stats.dbclass</name>
<value>jdbc:mysql</value>
</property>

<property>
<name>hive.stats.jdbcdriver</name>
<value>com.mysql.jdbc.Driver</value>
</property>

<property>
<name>hive.stats.dbconnectionstring</name>
<value>jdbc:mysql://hadoop23:3306/hive_stats?useUnicode=true&characterEncoding=latin1&user=hive&password=hivepwd&createDatabaseIfNotExist=true</value>
</property>

<property>
<name>hive.stats.dbconnectionstring</name>
<value>jdbc:mysql://hadoop23:3306/hive_stats?useUnicode=true&characterEncoding=utf8&user=hive&password=hivepwd&createDatabaseIfNotExist=true</value>
</property>

<property>
<name>hive.metastore.uris</name>
<value>thrift://hadoop23:9083</value>
</property>

<property>
<name>hive.querylog.location</name>
<value>/data6/hive/${user.name}</value>
<description>
Location of Hive run time structured log file
</description>
</property>

<property>
<name>hive.aux.jars.path</name>
<value>file:///home/hadoop/hive/lib/hive-hbase-handler-0.10.0.jar,file:///home/hadoop/hbase/hbase-0.94.7.jar,file:///home/hadoop/hbase/lib/zookeeper-3.4.5.jar</value>
</property>

<property>
<name>hbase.zookeeper.quorum</name>
<value>hb1,hb2,hb3</value>
</property>

</configuration>