hive安装和配置

1. mysql安装

安装mysql，新建用户，新建hive数据库

grant all on *.* to hive@'%' identified by 'hive' with grant option; #新建用户
grant all privileges on *.* to 'root'@'%' identified by 'root'; # 设置远程连接权限
flush privileges;

2.安装hive，配置环境变量

• 配置hive-site.xml : 数据库连接配置

<configuration>
<property>  
  <name>hive.metastore.warehouse.dir</name>  
  <value>/usr/local/hive/warehouse</value>  
</property>  
<property>  
  <name>hive.metastore.local</name>  
  <value>true</value>  
</property>  
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://127.0.0.1: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>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>
<property>
  <name>hive.metastore.schema.verification</name>
  <value>false</value>
   <description>
   Enforce metastore schema version consistency.
   True: Verify that version information stored in metastore matches with one from Hive 
jars.  Also disable automatic
         schema migration attempt. Users are required to manully migrate schema after Hi
ve upgrade which ensures
         proper metastore schema migration. (Default)
   False: Warn if the version information stored in metastore doesn't match with one fro
m in Hive jars.
   </description>
</property>
<property>
    <name>datanucleus.schema.autoCreateAll</name>
    <value>true</value>
    <description>creates necessary schema on a startup if one doesn't exist. set this to
 false, after creating it once</description>
 </property>
</configuration>

• 配置hive-env.sh脚本 : 配置hadoop目录

 HADOOP_HOME=/usr/local/hadoop

3. 拷贝mysql-connector.jar到hive的lib目录