Hadoop CDH4.4.0上HIVE安装

接上一篇Hadoop集群安装，hive是少不了的。简单记录下安装过程。

hive只在一个节点上安装就行，这里安装在hadoop-001

hadoop-001 10.168.204.55  hive

hadoop-005 10.168.204.59  mysql

hadoop版本：CDH4.4.0

centos版本：6.3

一、准备

    1. 下载tarball

    

wget http://archive.cloudera.com/cdh4/cdh/4/hive-0.10.0-cdh4.4.0.tar.gz
tar -xvzf  hive-0.10.0-cdh4.4.0.tar.gz

二、配置

  1. metastore改为mysql

    

create user hive
create database hive
grant all privileges on hive.* to 'hive'@'10.168.255.55' identified by 'hive'

  2. hive-site.xml

  

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <!--<value>jdbc:derby:;databaseName=metastore_db;create=true</value>-->
  <value>jdbc:mysql://10.168.204.59:3306/hive?createDatabaseIfNotExist=true</value>
  <description>JDBC connect string 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>

3. jdbc

    将mysql的jdbc driver 包扔到 hive/lib/ 目录下.

     http://dev.mysql.com/downloads/connector/j/  下载最新的mysql driver

  

三、启动

    cd hive/bin

    ./hive

四、遇到的问题

微博：http://weibo.com/kingjames3