DBeaver连接Kyuubi成功,但不能获取catalog

关键信息如下标红,

operationHandle字段未设置,这个很容易想到是版本不一致,在DBeaver里修改kyuubi的驱动即可

 

asdfa

2023-06-12 08:55:29.756 INFO org.apache.kyuubi.server.KyuubiTBinaryFrontendService: Client protocol version: HIVE_CLI_SERVICE_PROTOCOL_V10
2023-06-12 08:55:29.757 INFO org.apache.kyuubi.session.KyuubiSessionManager: Opening session for hadoop@10.1.143.73
……省略部分日志
2023-06-12 08:55:29.866 INFO org.apache.curator.framework.imps.CuratorFrameworkImpl: backgroundOperationsLoop exiting
2023-06-12 08:55:29.869 INFO org.apache.zookeeper.ZooKeeper: Session: 0x304ee68cbe00c68 closed
2023-06-12 08:55:29.869 INFO org.apache.zookeeper.ClientCnxn: EventThread shut down for session: 0x304ee68cbe00c68
2023-06-12 08:55:29.869 INFO org.apache.kyuubi.operation.LaunchEngine: Processing hadoop's query[1999c2d9-f685-4f7f-b70e-a6c946a2c003]: RUNNING_STATE -> FINISHED_STATE, time taken: 0.11 seconds
2023-06-12 08:55:29.878 ERROR org.apache.kyuubi.server.KyuubiTBinaryFrontendService: Error fetching results:
org.apache.thrift.protocol.TProtocolException: Required field 'operationHandle' is unset! Struct:TFetchResultsReq(operationHandle:null, orientation:FETCH_NEXT, maxRows:1000, fetchType:0)
        at org.apache.hive.service.rpc.thrift.TFetchResultsReq.validate(TFetchResultsReq.java:548) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.hive.service.rpc.thrift.TCLIService$FetchResults_args.validate(TCLIService.java:15755) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.hive.service.rpc.thrift.TCLIService$FetchResults_args$FetchResults_argsStandardScheme.write(TCLIService.java:15812) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.hive.service.rpc.thrift.TCLIService$FetchResults_args$FetchResults_argsStandardScheme.write(TCLIService.java:15781) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.hive.service.rpc.thrift.TCLIService$FetchResults_args.write(TCLIService.java:15732) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.thrift.TServiceClient.sendBase(TServiceClient.java:71) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.thrift.TServiceClient.sendBase(TServiceClient.java:62) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.hive.service.rpc.thrift.TCLIService$Client.send_FetchResults(TCLIService.java:561) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.hive.service.rpc.thrift.TCLIService$Client.FetchResults(TCLIService.java:553) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.kyuubi.client.KyuubiSyncThriftClient.$anonfun$fetchResults$1(KyuubiSyncThriftClient.scala:386) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.client.KyuubiSyncThriftClient.$anonfun$withLockAcquiredAsyncRequest$2(KyuubiSyncThriftClient.scala:136) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_202]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) ~[?:1.8.0_202]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) ~[?:1.8.0_202]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_202]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_202]
        at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_202]
2023-06-12 08:55:29.892 INFO org.apache.kyuubi.session.KyuubiSessionImpl: [hadoop:192.168.137.1] SessionHandle [3d715c31-6619-4fea-877e-850c1a380ce2] - Starting to wait the launch engine operation finished
2023-06-12 08:55:29.892 INFO org.apache.kyuubi.session.KyuubiSessionImpl: [hadoop:192.168.137.1] SessionHandle [3d715c31-6619-4fea-877e-850c1a380ce2] - Engine has been launched, elapsed time: 0 s
2023-06-12 08:55:29.892 INFO org.apache.kyuubi.operation.GetTables: Processing hadoop's query[2a2fe02a-b1be-4ff7-875e-0d3ea6173814]: INITIALIZED_STATE -> RUNNING_STATE, statement:
GetTables
2023-06-12 08:55:29.897 INFO org.apache.kyuubi.operation.GetTables: Processing hadoop's query[2a2fe02a-b1be-4ff7-875e-0d3ea6173814]: RUNNING_STATE -> ERROR_STATE, time taken: 0.005 seconds
2023-06-12 08:55:29.903 ERROR org.apache.kyuubi.server.KyuubiTBinaryFrontendService: Error getting tables:
org.apache.kyuubi.KyuubiSQLException: Error operating GetTables: org.apache.thrift.TApplicationException: GetTables failed: out of sequence response
        at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:84)
        at org.apache.hive.service.rpc.thrift.TCLIService$Client.recv_GetTables(TCLIService.java:337)
        at org.apache.hive.service.rpc.thrift.TCLIService$Client.GetTables(TCLIService.java:324)
        at org.apache.kyuubi.client.KyuubiSyncThriftClient.$anonfun$getTables$1(KyuubiSyncThriftClient.scala:265)
        at org.apache.kyuubi.client.KyuubiSyncThriftClient.$anonfun$withLockAcquiredAsyncRequest$2(KyuubiSyncThriftClient.scala:136)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)

        at org.apache.kyuubi.KyuubiSQLException$.apply(KyuubiSQLException.scala:69) ~[kyuubi-common_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.operation.KyuubiOperation$$anonfun$onError$1.applyOrElse(KyuubiOperation.scala:75) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.operation.KyuubiOperation$$anonfun$onError$1.applyOrElse(KyuubiOperation.scala:56) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at scala.runtime.AbstractPartialFunction.apply(AbstractPartialFunction.scala:38) ~[scala-library-2.12.15.jar:?]
        at org.apache.kyuubi.operation.GetTables.runInternal(GetTables.scala:33) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.operation.AbstractOperation.run(AbstractOperation.scala:164) ~[kyuubi-common_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.session.AbstractSession.runOperation(AbstractSession.scala:99) ~[kyuubi-common_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.session.KyuubiSessionImpl.runOperation(KyuubiSessionImpl.scala:151) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.session.AbstractSession.getTables(AbstractSession.scala:160) ~[kyuubi-common_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.service.AbstractBackendService.getTables(AbstractBackendService.scala:94) ~[kyuubi-common_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.server.KyuubiServer$$anon$1.org$apache$kyuubi$server$BackendServiceMetric$$super$getTables(KyuubiServer.scala:111) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.server.BackendServiceMetric.$anonfun$getTables$1(BackendServiceMetric.scala:94) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.metrics.MetricsSystem$.timerTracing(MetricsSystem.scala:111) ~[kyuubi-metrics_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.server.BackendServiceMetric.getTables(BackendServiceMetric.scala:94) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.server.BackendServiceMetric.getTables$(BackendServiceMetric.scala:87) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.server.KyuubiServer$$anon$1.getTables(KyuubiServer.scala:111) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.service.TFrontendService.GetTables(TFrontendService.scala:316) ~[kyuubi-common_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.hive.service.rpc.thrift.TCLIService$Processor$GetTables.getResult(TCLIService.java:1637) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.hive.service.rpc.thrift.TCLIService$Processor$GetTables.getResult(TCLIService.java:1622) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.kyuubi.service.authentication.TSetIpAddressProcessor.process(TSetIpAddressProcessor.scala:36) ~[kyuubi-common_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) ~[libthrift-0.9.3.jar:0.9.3]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_202]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_202]
        at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_202]
Caused by: org.apache.thrift.TApplicationException: GetTables failed: out of sequence response
        at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:84) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.hive.service.rpc.thrift.TCLIService$Client.recv_GetTables(TCLIService.java:337) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.hive.service.rpc.thrift.TCLIService$Client.GetTables(TCLIService.java:324) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.kyuubi.client.KyuubiSyncThriftClient.$anonfun$getTables$1(KyuubiSyncThriftClient.scala:265) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.client.KyuubiSyncThriftClient.$anonfun$withLockAcquiredAsyncRequest$2(KyuubiSyncThriftClient.scala:136) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_202]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) ~[?:1.8.0_202]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) ~[?:1.8.0_202]
        ... 3 more
2023-06-12 08:55:29.944 INFO org.apache.kyuubi.server.KyuubiTBinaryFrontendService: Received request of closing SessionHandle [3d715c31-6619-4fea-877e-850c1a380ce2]
2023-06-12 08:55:29.944 INFO org.apache.kyuubi.session.KyuubiSessionManager: SessionHandle [3d715c31-6619-4fea-877e-850c1a380ce2] is closed, current opening sessions 2
2023-06-12 08:55:30.052 ERROR org.apache.kyuubi.server.KyuubiTBinaryFrontendService: Error closing session:
org.apache.kyuubi.KyuubiSQLException: Error while cleaning up the engine resources
        at org.apache.kyuubi.KyuubiSQLException$.apply(KyuubiSQLException.scala:69) ~[kyuubi-common_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.client.KyuubiSyncThriftClient.closeSession(KyuubiSyncThriftClient.scala:193) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.session.KyuubiSessionImpl.close(KyuubiSessionImpl.scala:192) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.session.SessionManager.closeSession(SessionManager.scala:127) ~[kyuubi-common_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.session.KyuubiSessionManager.closeSession(KyuubiSessionManager.scala:111) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.service.AbstractBackendService.closeSession(AbstractBackendService.scala:49) ~[kyuubi-common_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.server.KyuubiServer$$anon$1.org$apache$kyuubi$server$BackendServiceMetric$$super$closeSession(KyuubiServer.scala:111) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.server.BackendServiceMetric.$anonfun$closeSession$1(BackendServiceMetric.scala:43) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at scala.runtime.java8.JFunction0$mcV$sp.apply(JFunction0$mcV$sp.java:23) ~[scala-library-2.12.15.jar:?]
        at org.apache.kyuubi.metrics.MetricsSystem$.timerTracing(MetricsSystem.scala:111) ~[kyuubi-metrics_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.server.BackendServiceMetric.closeSession(BackendServiceMetric.scala:43) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.server.BackendServiceMetric.closeSession$(BackendServiceMetric.scala:41) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.server.KyuubiServer$$anon$1.closeSession(KyuubiServer.scala:111) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.service.TFrontendService.CloseSession(TFrontendService.scala:197) ~[kyuubi-common_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.hive.service.rpc.thrift.TCLIService$Processor$CloseSession.getResult(TCLIService.java:1517) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.hive.service.rpc.thrift.TCLIService$Processor$CloseSession.getResult(TCLIService.java:1502) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.kyuubi.service.authentication.TSetIpAddressProcessor.process(TSetIpAddressProcessor.scala:36) ~[kyuubi-common_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) ~[libthrift-0.9.3.jar:0.9.3]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_202]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_202]
        at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_202]
Caused by: org.apache.thrift.transport.TTransportException
        at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.thrift.transport.TSaslTransport.readLength(TSaslTransport.java:376) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.thrift.transport.TSaslTransport.readFrame(TSaslTransport.java:453) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.thrift.transport.TSaslTransport.read(TSaslTransport.java:435) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.thrift.transport.TSaslClientTransport.read(TSaslClientTransport.java:37) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.thrift.protocol.TBinaryProtocol.readStringBody(TBinaryProtocol.java:380) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:230) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:77) ~[libthrift-0.9.3.jar:0.9.3]
        at org.apache.hive.service.rpc.thrift.TCLIService$Client.recv_CloseSession(TCLIService.java:199) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.hive.service.rpc.thrift.TCLIService$Client.CloseSession(TCLIService.java:186) ~[hive-service-rpc-3.1.3.jar:3.1.3]
        at org.apache.kyuubi.client.KyuubiSyncThriftClient.$anonfun$closeSession$1(KyuubiSyncThriftClient.scala:188) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at org.apache.kyuubi.client.KyuubiSyncThriftClient.$anonfun$withLockAcquiredAsyncRequest$2(KyuubiSyncThriftClient.scala:136) ~[kyuubi-server_2.12-1.6.0-incubating.jar:1.6.0-incubating]
        at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_202]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) ~[?:1.8.0_202]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) ~[?:1.8.0_202]
        ... 3 more
2023-06-12 08:55:30.054 INFO org.apache.kyuubi.server.KyuubiTBinaryFrontendService: Finished closing SessionHandle [3d715c31-6619-4fea-877e-850c1a380ce2]

 

posted @ 2023-06-12 09:15  江南叶少  阅读(406)  评论(0编辑  收藏  举报