hive的安装
1:上传解压hive tar -zxvf ***** /usr/local/
2:安装mysql,添加开机自启 chkconfig mysql on
3:配置hive-site.xml 在安装目录/conf下新建,粘贴下面这段代码(高版本mysql需要ssl)
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?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>root</value>
<description>password to use against metastore database</description>
</property>
</configuration>
4:添加mysql*.jar 添加到$HIVE_HOME/lib 一个Mysql的驱动包,版本不限
5:添加到path环境变量里面
6:source /etc/profile
7:nohup hiveserver2 //hadoop集群必须开启,其他节点hive必须配置好
//配置好一台机器, scp命令发送省时省力
8.beeline连接
!connect jdbc:hive2://jiqun01:10000
输入用户密码