(1) 把apache-hive-0.14.0-bin.tar.gz拖到/usr/local下;
(2) 执行tar -zxvf apache-hive-0.14.0-bin.tar.gz 解压缩;
(3) 执行mv apache-hive-0.14.0-bin hive重命名;
(4) 在/usr/local/hive/conf下修改或者新建hive-site.xml文件 :内容如下
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://mycentOS6:3306/metastore?createDatabaseIfNotExist=true</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>123</value>
<description>password to use against metastore database</description>
</property>
</configuration>
(6) 执行cp hive-env.sh.template hive-env.sh产生新文件
在hive的derby配置中,derby只允许单用户访问其实例。
使用mysql替换derby作为hive的metastore
(1) 把mysql-connector-java-5.1.32-bin.jar放到hive的lib目录下;
(2) 把hive-site.xml放到hive的conf目录下【注意修改里面的url、password等】;