Hive入门

一、安装

下载后解压，配置很简单，底层是MR程序，所以只需要设置一下环境变量就可以使用了。

# hadoop的安装目录和hive的conf目录
# Set HADOOP_HOME to point to a specific hadoop install directory
HADOOP_HOME=/home/hadoop/cdh/hadoop-2.5.0-cdh5.3.6

# Hive Configuration Directory can be controlled by:
export HIVE_CONF_DIR=/home/hadoop/cdh/hive-0.13.1-cdh5.3.6/conf

进入hive进行测试

bin/hive
show databases;

二、案例

1、mysql数据库需要的配置

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://master:3306/hive?createDatabaseIfNotExists=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>x5</value>
  <description>password to use against metastore database</description>
</property>

2、接入hue需要的配置

<property>
  <name>hive.server2.thrift.port</name>
  <value>10000</value>
  <description>Port number of HiveServer2 Thrift interface.
  Can be overridden by setting $HIVE_SERVER2_THRIFT_PORT</description>
</property>

<property>
  <name>hive.server2.thrift.bind.host</name>
  <value>master</value>
  <description>Bind host on which to run the HiveServer2 Thrift interface.
  Can be overridden by setting $HIVE_SERVER2_THRIFT_BIND_HOST</description>
</property>

<property>
  <name>hive.metastore.uris</name>
  <value>thrift://master:9083</value>
</property>

启动hiveserver2

bin/hiveserver2

启动Hive Metastore Server

bin/hive --service metastore -p 9083