启动./beeline -u jdbc:hive2://hadoop000:10000时遇到如下问题
来源:6-3 thriftserver&beeline的使用

慕田峪0177977
2020-07-26
[hadoop@hadoop000 bin]$ ./beeline -u jdbc:hive2://hadoop000:10000
Connecting to jdbc:hive2://hadoop000:10000
20/07/26 22:24:15 INFO jdbc.Utils: Supplied authorities: hadoop000:10000
20/07/26 22:24:15 INFO jdbc.Utils: Resolved authority: hadoop000:10000
20/07/26 22:24:15 DEBUG auth.HiveAuthFactory: Cannot find private method “getKeytab” in class:org.apache.hadoop.security.UserGroupInformation
java.lang.NoSuchMethodException: org.apache.hadoop.security.UserGroupInformation.getKeytab()
at java.lang.Class.getDeclaredMethod(Class.java:2130)
at org.apache.hive.service.auth.HiveAuthFactory.(HiveAuthFactory.java:112)
at org.apache.hive.jdbc.HiveConnection.createBinaryTransport(HiveConnection.java:478)
at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:201)
at org.apache.hive.jdbc.HiveConnection.(HiveConnection.java:176)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at org.apache.hive.beeline.DatabaseConnection.connect(DatabaseConnection.java:142)
at org.apache.hive.beeline.DatabaseConnection.getConnection(DatabaseConnection.java:207)
at org.apache.hive.beeline.Commands.connect(Commands.java:1149)
at org.apache.hive.beeline.Commands.connect(Commands.java:1070)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hive.beeline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:52)
at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:970)
at org.apache.hive.beeline.BeeLine.initArgs(BeeLine.java:707)
at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:757)
at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484)
at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467)
20/07/26 22:24:16 INFO jdbc.HiveConnection: Will try to open client transport with JDBC Uri: jdbc:hive2://hadoop000:10000
20/07/26 22:24:16 DEBUG transport.TSaslTransport: opening transport org.apache.thrift.transport.TSaslClientTransport@51e2adc7
20/07/26 22:24:16 DEBUG transport.TSaslClientTransport: Sending mechanism name PLAIN and initial response of length 20
20/07/26 22:24:16 DEBUG transport.TSaslTransport: CLIENT: Writing message with status START and payload length 5
20/07/26 22:24:16 DEBUG transport.TSaslTransport: CLIENT: Writing message with status COMPLETE and payload length 20
20/07/26 22:24:16 DEBUG transport.TSaslTransport: CLIENT: Start message handled
20/07/26 22:24:16 DEBUG transport.TSaslTransport: CLIENT: Main negotiation loop complete
20/07/26 22:24:16 DEBUG transport.TSaslTransport: CLIENT: SASL Client receiving last message
20/07/26 22:24:16 DEBUG transport.TSaslTransport: CLIENT: Received message with status COMPLETE and payload length 0
20/07/26 22:24:16 DEBUG transport.TSaslTransport: writing data length: 71
20/07/26 22:24:16 DEBUG transport.TSaslTransport: CLIENT: reading data length: 109
20/07/26 22:24:16 DEBUG transport.TSaslTransport: writing data length: 85
20/07/26 22:24:16 DEBUG transport.TSaslTransport: CLIENT: reading data length: 55
20/07/26 22:24:16 DEBUG transport.TSaslTransport: writing data length: 85
20/07/26 22:24:16 DEBUG transport.TSaslTransport: CLIENT: reading data length: 51
Connected to: Spark SQL (version 2.4.3)
Driver: Hive JDBC (version 1.2.1.spark2)
Transaction isolation: TRANSACTION_REPEATABLE_READ
20/07/26 22:24:16 DEBUG beeline.SQLCompleter: fail to get SQL key words from database metadata due to the exception: java.sql.SQLException: Method not supported
java.sql.SQLException: Method not supported
at org.apache.hive.jdbc.HiveDatabaseMetaData.getSQLKeywords(HiveDatabaseMetaData.java:547)
at org.apache.hive.beeline.SQLCompleter.getSQLCompleters(SQLCompleter.java:56)
at org.apache.hive.beeline.DatabaseConnection.setCompletions(DatabaseConnection.java:83)
at org.apache.hive.beeline.BeeLine.setCompletions(BeeLine.java:1871)
at org.apache.hive.beeline.Commands.connect(Commands.java:1152)
at org.apache.hive.beeline.Commands.connect(Commands.java:1070)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.hive.beeline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:52)
at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:970)
at org.apache.hive.beeline.BeeLine.initArgs(BeeLine.java:707)
at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:757)
at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:484)
at org.apache.hive.beeline.BeeLine.main(BeeLine.java:467)
Beeline version 1.2.1.spark2 by Apache Hive
0: jdbc:hive2://hadoop000:10000>
1回答
-
Michael_PK
2020-07-26
你的环境里面是不是有spark,你看最后的日志,走的hive是spark的版本。你执行的时候去hive的bin下,脚本前面加个./,确保走的是hive的beeline,因为spark里面也有beeline,
10
相似问题