安装环境:
Hadoop:hadoop-2.7.2
Java:jdk1.8.0_73
hive:apache-hive-2.0.0-bin
安装步骤:
1、解压hive压缩包
2、配置环境变量: vim /etc/profile
3、复制hive-default.xml并重命名为hive-site.xml和hive-default.xml
cp hive-default.xml.template hive-default.xml
cp hive-default.xml.template hive-site.xml
4、创建hive目录,手动创建好目录,并修改hive-site.xml
<property>
<name>hive.downloaded.resources.dir</name>
<value>/user/hive/downloaded</value>
</property>
<property>
<name>hive.exec.local.scratchdir</name>
<value>/user/hive/scratchdir</value>
</property>
其中这两个目录需要手动创建好。
5、配置mysql元数据库。
确保mysql数据库已经开启外部链接,将mysql-connector-java-5.1.26-bin.jar拷贝到hive的lib目录下。
修改hive-site.xml文件中的内容:
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.60.141:3306/hive?createDatabaseIfNotExist=true</value>
<description>JDBC connect string 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>123456</value>
<description>password to use against metastore database</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>