Hive安装配置

1、安装MySQL

详见centos7安装配置mysql

2、创建数据库

mysql> CREATE DATABASE `hive` CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON hive.* TO hive@'%' IDENTIFIED BY 'hive';
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

3、下载Hive包，并解压

4、配置hive-site.xml

<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.ConnectionURL</name>
    <value>jdbc:mysql://ip:3306/hive?createDatabaseIfNotExist=true&amp;characterEncoding=UTF-8</value>
</property>
<property>
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>hive</value>
    <description>Username to use against metastore database</description>
</property>
<property>
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>hive</value>
    <description>password to use against metastore database</description>
</property>

5、启动

nohup hive --service metastore >> $HIVE_HOME/log/metasotre.log 2>&1 &
nohup hive --service hiveserver2 >> $HIVE_HOME/log/hiveserver.log 2>&1 &

6、QA

1）Caused by: MetaException(message:Version information not found in metastore. )

修改配置：

<property>
    <name>hive.metastore.schema.verification</name>
    <value>false</value>
</property>

2）DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.schema.autoCreateTables"

使用以下命令初始化元数据即可：

schematool -dbType mysql -initSchema