一.安装
1.下载http://apache.fayea.com/apache-mirror/hive/hive-0.10.0/hive-0.10.0.tar.gz
2.解压到当前用户的hive目录下:tar -zxvf hive-0.10.0.tar.gz /home/long1657/hive
3.配置环境变量:vim ~/.bashrc
export HIVE_HOME=/home/long1657/hive/hive-0.10.0
export PATH=$PATH:$HIVE_HOME/bin
source ~/.bashrc
4.把hive/conf目录下的四个文件重命名:
mv hive-default.xml.template hive-site.xml
mv hive-env.sh.template hive-env.sh
mv hive-exec-log4j.properties.template hive-exec-log4j.properties
mv hive-log4j.properties.template hive-log4j.properties
4.配置hive-env.sh
指定hive配置文件的路径
export HIVE_CONF_DIR=/home/long1657/hive/hive-0.10.0/conf(你的hive配置文件路径)
指定Hadoop路径
HADOOP_HOME=/home/long1657/hadoop/hadoop-0.20.2(你的hadoop安装目录)
二.使用Derby数据库的安装方式
什么是Derby安装方式
Apache Derby是一个完全用java编写的数据库,所以可以跨平台,但需要在JVM中运行
Derby是一个Open source的产品,基于Apache License 2.0分发
即将元数据存储在Derby数据库中,也是Hive默认的安装方式
即:默认的hive-size.xml中的配置如下:
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:derby:;databaseName=metastore_db;create=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>org.apache.derby.jdbc.EmbeddedDriver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>APP</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>mine</value>
<description>password to use against metastore database</description>
</property>
此时通过:hive命令
WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files.
Logging initialized using configuration in jar:file:/home/test/Desktop/hive-0.8.1/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/test/hive_job_log_test_201208260529_167273830.txt
hive> show tables;
现实具体的表,上诉表示安装成功。
三.使用MySQL数据库作为hive的metastore的安装方式
通过第一个我们安装好了hive
1.现在需要安装mysql-server:
sudo apt-get install mysql-server
2.安装好登录mysql:mysql -h localhost -u root -p
3.在mysql内创建hive的用户:create user 'myHive'@'localhost' IDENTIFIED BY 'myHive';
4.给myHive授权:grant all privileges on *.* 'myHive'@'localhost' with grant option;
5.配置hive配置文件hive-site.xml:
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>myHive</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>myHive</value>
</property>
6.下载 mysql-connector-java-5.1.24-bin.jar,放到hive的lib目录;
此时通过:hive命令
WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files.
Logging initialized using configuration in jar:file:/home/test/Desktop/hive-0.8.1/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/test/hive_job_log_test_201208260529_167273830.txt
hive> show tables;
使用mysql作为hive的matestore安装完成!
1.下载http://apache.fayea.com/apache-mirror/hive/hive-0.10.0/hive-0.10.0.tar.gz
2.解压到当前用户的hive目录下:tar -zxvf hive-0.10.0.tar.gz /home/long1657/hive
3.配置环境变量:vim ~/.bashrc
export HIVE_HOME=/home/long1657/hive/hive-0.10.0
export PATH=$PATH:$HIVE_HOME/bin
source ~/.bashrc
4.把hive/conf目录下的四个文件重命名:
mv hive-default.xml.template hive-site.xml
mv hive-env.sh.template hive-env.sh
mv hive-exec-log4j.properties.template hive-exec-log4j.properties
mv hive-log4j.properties.template hive-log4j.properties
4.配置hive-env.sh
指定hive配置文件的路径
export HIVE_CONF_DIR=/home/long1657/hive/hive-0.10.0/conf(你的hive配置文件路径)
指定Hadoop路径
HADOOP_HOME=/home/long1657/hadoop/hadoop-0.20.2(你的hadoop安装目录)
二.使用Derby数据库的安装方式
什么是Derby安装方式
Apache Derby是一个完全用java编写的数据库,所以可以跨平台,但需要在JVM中运行
Derby是一个Open source的产品,基于Apache License 2.0分发
即将元数据存储在Derby数据库中,也是Hive默认的安装方式
即:默认的hive-size.xml中的配置如下:
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:derby:;databaseName=metastore_db;create=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>org.apache.derby.jdbc.EmbeddedDriver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>APP</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>mine</value>
<description>password to use against metastore database</description>
</property>
此时通过:hive命令
WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files.
Logging initialized using configuration in jar:file:/home/test/Desktop/hive-0.8.1/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/test/hive_job_log_test_201208260529_167273830.txt
hive> show tables;
现实具体的表,上诉表示安装成功。
三.使用MySQL数据库作为hive的metastore的安装方式
通过第一个我们安装好了hive
1.现在需要安装mysql-server:
sudo apt-get install mysql-server
2.安装好登录mysql:mysql -h localhost -u root -p
3.在mysql内创建hive的用户:create user 'myHive'@'localhost' IDENTIFIED BY 'myHive';
4.给myHive授权:grant all privileges on *.* 'myHive'@'localhost' with grant option;
5.配置hive配置文件hive-site.xml:
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>myHive</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>myHive</value>
</property>
6.下载 mysql-connector-java-5.1.24-bin.jar,放到hive的lib目录;
此时通过:hive命令
WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files.
Logging initialized using configuration in jar:file:/home/test/Desktop/hive-0.8.1/lib/hive-common-0.8.1.jar!/hive-log4j.properties
Hive history file=/tmp/test/hive_job_log_test_201208260529_167273830.txt
hive> show tables;
使用mysql作为hive的matestore安装完成!