hive的安装配置

hive只需安装在一个节点上。

1、将安装包解压，cd入conf文件夹下，执行命令cp hive-default.xml hive-site.xml

2、更改hive-site.xml的配置项

</property>

    <name>javax.jdo.option.ConnectionURL</name> 

    <value>jdbc:mysql://主机名: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>root用户在MySQL中的密码</value> 

    <description>password to use against metastore database</description>

</property>

3、将MySQL的Java驱动包放置在lib文件夹下

4、使用bin/hive启动hive的客户端