09 Hive安装与配置

一、hive下载

1.下载并解压hive源程序，重命名，权限

hive下载官网：http://www.apache.org/dyn/closer.cgi/hive/

sudo tar -zxvf ./apache-hive-1.2.1-bin.tar.gz -C /usr/local #解压到/usr/local中

cd /usr/local

sudo mv apache-hive-1.2.1-bin hive #将文件夹名改为hive

sudo chown -R hadoop:hadoop hive #修改文件权限

2.配置环境变量

编辑~/.bashrc配置，将hive命令加入到环境变量中去，配置完成后使其生效

查看路径；修改文件夹权限；查看版本

3.修改配置文件

 1 <?xml version="1.0" encoding="UTF-8" standalone="no"?>
 2 <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
 3 <configuration>
 4   <property>
 5     <name>javax.jdo.option.ConnectionURL</name>
 6     <value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>
 7     <description>JDBC connect string for a JDBC metastore</description>
 8   </property>
 9   <property>
10     <name>javax.jdo.option.ConnectionDriverName</name>
11     <value>com.mysql.jdbc.Driver</value>
12     <description>Driver class name for a JDBC metastore</description>
13   </property>
14   <property>
15     <name>javax.jdo.option.ConnectionUserName</name>
16     <value>hive</value>
17     <description>username to use against metastore database</description>
18   </property>
19   <property>
20     <name>javax.jdo.option.ConnectionPassword</name>
21     <value>hive</value>
22     <description>password to use against metastore database</description>
23   </property>
24 </configuration>