1 下载hadoop,java包并进行安装,并将路径加入环境变量。
在hdfs文件系统中建立数据仓库
user@ubuntu:~$ hdfs dfs -mkdir -p /user/hive/warehouse
2 下载hive压缩包,并解压到指定目录。
tar -zxvf apache-hive-1.2.2-bin.tar.gz
3 将hive路径添加到环境变量
vim /etc/profile
export HIVE_HOME=/path/to/your/hive
export PATH=$HIVE_HOME:$PATH
4 下载mysql数据库
网上有大量相关文章
安装完成后配置元数据
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
将java连接mysql数据库的jar包放入/hive/lib/目录下
5 修改配置文件
cd /path/to/your/hive/conf
1. cp hive-env.sh.template hive-env.sh
vim hive-env.sh 添加以下内容
HADOOP_HOME=/path/to/your/hadoop-2.7.4
export HIVE_CONF_DIR=/path/to/your/hive/conf
export HIVE_HOME=/path/to/your/hive
2. touch hive-site.xml
vim hive-site.xml 添加以下内容
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?useSSL=false&createDatabaseIfNotExist=true&characterEncoding=UTF-8</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>password</value>
<description>password to use against metastore database</description>
</property>
</configuration>
6 启动hive
在shell中键入hive,即可进入hive
user@ubuntu:~$ hive