hive用mysql作元数据代替默认derby的hive-site.xml配置 

<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://server110:3306/hive?createDatabaseIfNotExist=true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>root</value>
</property>


<!--注意要上传mysql驱动到hive的lib文件夹-->

 

posted @ 2017-11-25 16:46  ぶ会编程  阅读(1004)  评论(0)  编辑  收藏  举报