hive单用户的安装

hive单用户的安装

在node09中安装：
【1】上传jar包并解压
	tar  zxvf  apache-hive-1.2.1-bin.tar.gz
【2】移动解压包到/opt/sxt
	mv apache-hive-1.2.1-bin /opt/sxt/
【3】修改配置文件
	vi /etc/profile
	export HIVE_HOME=/opt/sxt/apache-hive-1.2.1-bin
	export PATH=$PATH:$JAVA_HOME/bin:$HADOOP_PREFIX/bin:$HADOOP_PREFIX/sbin:$ZOOKEEPER_PREFIX/bin:$HIVE_HOME/bin
【4】刷新配置文件
	.	/etc/profile
【5】修改hive-site.xml
	cp hive-default.xml.template hive-site.xml
	vi hive-site.xml

<configuration>
<property>  
  <name>hive.metastore.warehouse.dir</name>  
  <value>/user/hive_remote/warehouse</value>  
</property>  
   
<property>  
  <name>hive.metastore.local</name>  
  <value>true</value>  
</property>  
   
<property>  
  <name>javax.jdo.option.ConnectionURL</name>  
  <value>jdbc:mysql://node08/hive_remote?createDatabaseIfNotExist=true&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;useSSL=false</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>ZZyy123@sai</value>  
</property>  

【6】上传mysql  jar包
 	cp mysql-connector-java-5.1.47.jar     /opt/sxt/apache-hive-1.2.1-bin/lib/
【7】统一Hadoop（删除不同的版本）和Hive  jar包版本问题
	rm /opt/sxt/hadoop-2.6.5/share/hadoop/yarn/lib/jline-0.9.94.jar
	cp /opt/sxt/apache-hive-1.2.1-bin/lib/jline-2.12.jar   	/opt/sxt/hadoop-2.6.5/share/hadoop/yarn/lib
【8】启动
	cd /opt/sxt/apache-hive-1.2.1-bin/bin
	./hive

<-------------------------------------------------------->
报：
Logging initialized using configuration in jar:file:/opt/sxt/apache-hive-1.2.1-bin/lib/hive-common-1.2.1.jar!/hive-log4j.properties
Thu Apr 04 09:45:41 EDT 2019 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

原因： MySQL的版本过高
解决：
<property>  
  <name>javax.jdo.option.ConnectionURL</name>  
  <value>jdbc:mysql://node08/hive_remote?createDatabaseIfNotExist=true&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;useSSL=false</value>  
</property>