This post is about the installation of Hive on Ubuntu. The environment of my system is ubuntu12.04, hadoop1.0.3, hive 0.9.0. Supposing the hadoop is installed.
The details of installation for hive describe as follows:
step 1: download hive-0.9.0.tar.gz from the url: http://hive.apache.org/index.html
step 2: uncompress the above file using linux command in the shell.
- $ sudo tar -xzf hive-0.10.0.tar.gz
step 3: copy the uncompressed files to the directory /home/hadoop/.
- $ sudo cp -r /home/eboss/hive /usr/local/hadoop/
-
$ mvhive-0.10.0
hive
step 4: entry the configure directory of hive and copy the configure file.
- $ cd /usr/local/hadoop/hive/conf
- $ sudo cp hive-env.sh.template hive-env.sh
step 5: modify the configure file in the last line as follows:
- $ sudo gedit /usr/local/hadoop/hive/conf/hive-env.sh
- #add the below configure information
- export Hadoop_HOME=/usr/local/hadoop/
- export HIVE_HOME=/usr/local/hadoop/hive
- export PATH=$PATH:/usr/local/hadoop/hive/bin
step 6: change the directory of hive to the hadoop user.
- $ sudo chown -R hadoop:hadoop hive
step 7: start hive and test hive
- $ bin/hive or bin/hive start or ./hive
- $ show tables;
- $ create database hive;
- $ use hive;
- $ create table test(id int,name string);
step 8: modify hive-exec-log4j.properties.template
- mv conf/hive-exec-log4j.properties.template conf/hive-exec-log4j.properties
- 如果不修改此文件的话 启动hive时会出现警告信息的
step 8: 配置hive支持mysql数据的导入
- 要把mysql-connector-java-5.1.22-bin.jar 复制到 hive/lib目录下
- 如果不修改此文件的话 启动hive时会出现警告信息的
444