tar zxvf apache-hive-2.1.1-bin.tar.gz
配置环境变量
sudo vi ~/.bashrc:
export HIVE_HOME=/opt/apache-hive-2.1.1-bin
export PATH=$HIVE_HOME/bin:$PATH
安装mysql
作为metastore的储存
配置Hive
cp hive-default.xml.template hive-default.xml
vi hive-site.xml:
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.70.1:3306/hive?createDatabaseIfNotExist=true
&useUnicode=true&characterEncoding=utf-8&useSSL=false&</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>hive</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hive</value>
<description>password to use against metastore database</description>
</property>
<property>
<name>hive.metastore.schema.verification</name>
<value>false</value>
<description>
Enforce metastore schema version consistency.
True: Verify that version information stored in metastore matches with one f
rom Hive jars. Also disable automatic
schema migration attempt. Users are required to manully migrate schema
after Hive upgrade which ensures
proper metastore schema migration. (Default)
False: Warn if the version information stored in metastore doesn't match wit
h one from in Hive jars.
</description>
</property>
<property>
<name>datanucleus.schema.autoCreateTables</name>
<value>true</value>
</property>
<property>
<name>hive.metastore.sasl.enabled</name>
<value>false</value>
<description>If true, the metastore Thrift interface will be secured with SASL
. Clients must authenticate with Kerberos.</description>
</property>
<property>
<name>hive.server2.enable.doAs</name>
<value>true</value>
</property>
<property>
<name>hive.server2.authentication</name>
<value>NONE</value>
</property>
</configuration>
安装Mysql JDBC驱动
下载 mysql-connector-java-5.1.41-bin.jar
cp mysql-connector-java-5.1.41-bin.jar /opt/apache-hive-2.1.1-bin/lib
配置Hive用户
在Hadoop的core-site.xml上加上hive用户的配置:
vi etc/hadoop/core-site.xml:
<!-- 定义hive用户vagrant -->
<property>
<name>hadoop.proxyuser.vagrant.groups</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.vagrant.hosts</name>
<value>*</value>
</property>
重启启动Hadoop使配置生效:
stop-dfs.sh
stop-yarn.sh
hadoop-daemons.sh start journalnode
hadoop-daemons.sh start namenode
hadoop-daemons.sh start datanode
start-yarn.sh
hadoop-daemons.sh start zkfc
启动Hive
bin/hiveserver2
客户端连接Hive
beeline -u jdbc:hive2://192.168.70.103:10000 -n vagrant -p vagrant
show databases;
show tables;
select * from pokes;
访问 http://c7003:10002/ 可以查看hive服务器信息
界面客户端工具
下载Oracle SQL Developer:
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
下载Hive JDBC Driver for Oracle SQL Developer:
http://www.cloudera.com/downloads/connectors/hive/jdbc/2-5-15.html
解压,将Cloudera_HiveJDBC4_2.5.15.1040.zip解压
打开sqldeveloper.exe,点击”工具”–>“首选项”,在”数据库”–>”第三方JDBC驱动”中,添加Hive JDBC驱动。
重启sqldeveloper,就能看到可以建立Hive连接了。