2 Kylin install-hive

系统环境

OS:10.12.5 (16F73)
java version “1.8.0_121”
Hadoop 2.7.5
mysql Ver 14.14 Distrib 5.7.21
Hive 2.3.2

mysql安装

---

1. brew install mysql
2. /bin/sh /usr/local/opt/mysql/bin/mysqld_safe --datadir=/usr/local/var/mysql
3. 修改密码：SET PASSWORD FOR ‘root’@‘localhost’ = PASSWORD(‘newpass’);

hive安装

---

1. 下载
   http://hive.apache.org/

2. 配置

• 文件copy
  cd /usr/local/share/hive/conf
  cp hive-default.xml.template hive-site.xml
  cp hive-env.sh.template hive-env.sh
  cp hive-exec-log4j.properties.template hive-exec-log4j.properties
  cp hive-log4j.properties.template hive-log4j.properties

• hive-site.xml

<property>
    <name>hive.metastore.schema.verification</name>
    <value>false</value>
    <description>
      Enforce metastore schema version consistency.
      True: Verify that version information stored in is compatible with one from Hive jars.  Also disable automatic
            schema migration attempt. Users are required to manually migrate schema after Hive upgrade which ensures
            proper metastore schema migration. (Default)
      False: Warn if the version information stored in metastore doesn't match with one from in Hive jars.
    </description>
  </property>
  <property>
    <name>hive.metastore.warehouse.dir</name>
    <value>/Users/soft/apache-hive-2.3.2-bin/warehouse</value>
  </property>
  <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>root</value>
  </property>
  <property>
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>root</value>
  </property>
  <property>
    <name>datanucleus.autoCreateSchema</name>
    <value>true</value>
  </property>
  <property>
    <name>datanucleus.fixedDatastore</name>
    <value>true</value>
  </property>
  <property>
    <name>datanucleus.autoCreateTables</name>
    <value>True</value>
 </property>

• 加入mysql client jar
  把mysql-connector-java-5.1.34.jar copy到hive lib下

3. 运行测试

• /soft/apache-hive-2.3.2-bin/bin/hive
  • show databases;
  • show tables;
  • CREATE TABLE test (id INT, siteurl STRING);

4. 环境变量
   export HIVE_HOME=/Users/gongxinwen/soft/apache-hive-2.3.2-bin
   export PATH=$PATH:$HIVE_HOME/bin
   export HCAT_HOME=$HIVE_HOME/hcatalog

5. 管理页面
   http://localhost:50070/explorer.html#

参考资料

https://cwiki.apache.org/confluence/display/Hive/Home
http://blog.csdn.net/woshicsdn7547/article/details/51934735