beeline报错
来源:6-3 thriftserver&beeline的使用

慕九州3016327
2020-09-10
老师你好,我这个路径确实是spark下的bin目录下执行的,SparkSubmit也启动成功,为什么报这个错误呢:如下:
[hadoop@hadoop000 bin]$ ./beeline -u jdbc:hive2://hadoop000:10000
Connecting to jdbc:hive2://hadoop000:10000
20/09/11 06:45:26 INFO jdbc.Utils: Supplied authorities: hadoop000:10000
20/09/11 06:45:26 INFO jdbc.Utils: Resolved authority: hadoop000:10000
20/09/11 06:45:26 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/09/11 06:45:26 INFO jdbc.HiveConnection: Will try to open client transport with JDBC Uri: jdbc:hive2://hadoop000:10000
20/09/11 06:45:26 DEBUG transport.TSaslTransport: opening transport org.apache.thrift.transport.TSaslClientTransport@536aaa8d
20/09/11 06:45:26 DEBUG transport.TSaslClientTransport: Sending mechanism name PLAIN and initial response of length 20
20/09/11 06:45:26 DEBUG transport.TSaslTransport: CLIENT: Writing message with status START and payload length 5
20/09/11 06:45:26 DEBUG transport.TSaslTransport: CLIENT: Writing message with status COMPLETE and payload length 20
20/09/11 06:45:26 DEBUG transport.TSaslTransport: CLIENT: Start message handled
20/09/11 06:45:26 DEBUG transport.TSaslTransport: CLIENT: Main negotiation loop complete
20/09/11 06:45:26 DEBUG transport.TSaslTransport: CLIENT: SASL Client receiving last message
20/09/11 06:45:26 DEBUG transport.TSaslTransport: CLIENT: Received message with status COMPLETE and payload length 0
20/09/11 06:45:26 DEBUG transport.TSaslTransport: writing data length: 71
20/09/11 06:45:26 DEBUG transport.TSaslTransport: CLIENT: reading data length: 109
20/09/11 06:45:26 DEBUG transport.TSaslTransport: writing data length: 85
20/09/11 06:45:26 DEBUG transport.TSaslTransport: CLIENT: reading data length: 55
20/09/11 06:45:26 DEBUG transport.TSaslTransport: writing data length: 85
20/09/11 06:45:26 DEBUG transport.TSaslTransport: CLIENT: reading data length: 51
Connected to: Spark SQL (version 2.4.6)
Driver: Hive JDBC (version 1.2.1.spark2)
Transaction isolation: TRANSACTION_REPEATABLE_READ
20/09/11 06:45:26 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
3回答
-
Will try to open client transport with JDBC Uri: jdbc:hive2://hadoop000:10000
你的这个thrift的服务启动了吗
012020-09-11 -
Michael_PK
2020-09-10
看这个错误是连接到你hivesite的配置的元数据信息连不上
00 -
慕九州3016327
提问者
2020-09-10
启动了,这个SparkSubmit进程不就是thriftServer启动后的产物嘛
022020-09-11
相似问题