beeline连接hiveserver2 踩坑2小时！！

beeline连接hiveserver2的经历

• 首先metastore服务·

hive --service metastore &

• 首先安装好hive之后启动hiveserver2服务

[hadoop@localhost apache-hive-2.3.6-bin]$ hiveserver2 
which: no hbase in (/home/hadoop/app/jdk1.8.0_201/bin:/home/hadoop/app/jdk1.8.0_201/jre/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/hadoop/.local/bin:/home/hadoop/bin:/home/hadoop/app/apache-hive-2.3.6-bin/bin:/home/hadoop/app/hadoop-2.8.5/bin:/home/hadoop/app/hadoop-2.8.5/sbin:/home/hadoop/.local/bin:/home/hadoop/bin)
2020-02-27 05:16:25: Starting HiveServer2
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/hadoop/app/apache-hive-2.3.6-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/hadoop/app/hadoop-2.8.5/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]

• 开启另外一个窗口

[hadoop@hadoop101 hadoop]$ beeline -u jdbc:hive2://localhost:10000 -n hadoop 
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/hadoop/app/apache-hive-2.3.6-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/hadoop/app/hadoop-2.8.5/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Connecting to jdbc:hive2://localhost:10000
20/02/27 04:37:59 [main]: WARN jdbc.HiveConnection: Failed to connect to localhost:10000
Could not open connection to the HS2 server. Please check the server URI and if the URI is correct, then ask the administrator to check the server status.
Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000: java.net.ConnectException: Connection refused (Connection refused) (state=08S01,code=0)
Beeline version 2.3.6 by Apache Hive

报错！！！

• 检查报错

Please check the server URI and if the URI is correct, then ask the administrator to check the server status

这里的意思就是说使用jdbc连接mysql的URI出了问题，这时候就需要去hive-site.xml上检查一下是否写错！

• hive.site.xml

<property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://localhost:3306/metastore?createDatabaseIfNotExist=true&userSSL=false</value>
    <description>the URL of the MySQL database</description>
  </property>

发现问题 “?userSSL=false” 这个写法是有问题的 需要改写成：

<property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://localhost:3306/metastore?createDatabaseIfNotExist=true&amp;useSSL=false</value>
    <description>the URL of the MySQL database</description>
  </property>

为什么要添加userSSL呢是因为使用mysql版本是5.7+的所以需要添加。

• 最后使用beeline连接

[hadoop@hadoop101 hadoop]$ beeline -u jdbc:hive2://localhost:10000 -n hadoop 
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/hadoop/app/apache-hive-2.3.6-bin/lib/log4j-slf4j-impl-2.6.2.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/hadoop/app/hadoop-2.8.5/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Connecting to jdbc:hive2://localhost:10000
Connected to: Apache Hive (version 2.3.6)
Driver: Hive JDBC (version 2.3.6)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 2.3.6 by Apache Hive
0: jdbc:hive2://localhost:10000> show databases;
+----------------+
| database_name  |
+----------------+
| default        |
+----------------+
1 row selected (1.867 seconds)
0: jdbc:hive2://localhost:10000> 

成功！！！