Troubleshooting
Problem
Hive connection, (JDBC), returns the error: CDICO2060E: The metadata for the select statement could not be retrieved SQL syntax error: [IBM][Hive JDBC Driver][Hive]Error while compiling statement.
Symptom
CDICO2060E: The metadata for the select statement could not be retrieved SQL syntax error: [IBM][Hive JDBC Driver][Hive]Error while compiling statement: FAILED: ParseException line 1:68 cannot recognize input near '(' 'select' 'count' in expression specification.
[err] java.lang.NoSuchMethodException: io.grpc.netty.NettyWritableBuffer.<init>(io.netty.buffer.ByteBuf)
[err] at java.lang.Class.newNoSuchMethodException(Unknown Source)
[err] at java.lang.Class.getDeclaredConstructor(Unknown Source)
[err] at org.apache.arrow.flight.grpc.AddWritableBuffer.<clinit>(AddWritableBuffer.java:54)
[err] at org.apache.arrow.flight.ArrowMessage$DrainableByteBufInputStream.drainTo(ArrowMessage.java:519)
[err] at io.grpc.internal.MessageFramer.writeToOutputStream(MessageFramer.java:267)
[err] at [internal classes]
[err] at io.grpc.ForwardingServerCall.sendMessage(ForwardingServerCall.java:32)
[err] at io.openliberty.grpc.internal.monitor.GrpcMonitoringServerCall.sendMessage(GrpcMonitoringServerCall.java:53)
[err] at io.grpc.ForwardingServerCall.sendMessage(ForwardingServerCall.java:32)
[err] at io.grpc.stub.ServerCalls$ServerCallStreamObserverImpl.onNext(ServerCalls.java:380)
[err] at org.apache.arrow.flight.OutboundStreamListenerImpl.putNext(OutboundStreamListenerImpl.java:98)
[err] at org.apache.arrow.flight.OutboundStreamListenerImpl.putNext(OutboundStreamListenerImpl.java:77)
[err] at com.ibm.connect.flight.Producer.lambda$getStream$4(Producer.java:317)
[err] at com.ibm.connect.flight.Producer.connectWithRetry(Producer.java:681)
[err] at com.ibm.connect.flight.Producer.getStream(Producer.java:292)
[err] at com.ibm.wdp.connect.flight.RedirectProducer.getStream(RedirectProducer.java:215)
[err] at com.ibm.connect.flight.Producer.getStream(Producer.java:279)
[err] at com.ibm.wdp.connect.flight.Producer.getStream(Producer.java:216)
[err] at org.apache.arrow.flight.FlightService.doGetCustom(FlightService.java:111)
[err] at org.apache.arrow.flight.FlightBindingService$DoGetMethod.invoke(FlightBindingService.java:144)
[err] at org.apache.arrow.flight.FlightBindingService$DoGetMethod.invoke(FlightBindingService.java:134)
[err] at io.grpc.stub.ServerCalls$UnaryServerCallHandler$UnaryServerCallListener.onHalfClose(ServerCalls.java:182)
[err] at io.grpc.PartialForwardingServerCallListener.onHalfClose(PartialForwardingServerCallListener.java:35)
[err] at io.grpc.Contexts$ContextualizedServerCallListener.onHalfClose(Contexts.java:86)
[err] at io.grpc.PartialForwardingServerCallListener.onHalfClose(PartialForwardingServerCallListener.java:35)
[err] at io.grpc.Contexts$ContextualizedServerCallListener.onHalfClose(Contexts.java:86)
[err] at io.grpc.PartialForwardingServerCallListener.onHalfClose(PartialForwardingServerCallListener.java:35)
[err] at io.grpc.ForwardingServerCallListener.onHalfClose(ForwardingServerCallListener.java:23)
[err] at io.grpc.internal.ServerCallImpl$ServerStreamListenerImpl.halfClosed(ServerCallImpl.java:340)
[err] at [internal classes]
[err] at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[err] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[err] at java.lang.Thread.run(Unknown Source)
[WARNING ] [{ServletAdapter<3813>}] Exception writing message
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHGYS","label":"IBM Cloud Pak for Data"},"ARM Category":[{"code":"a8m50000000ClW7AAK","label":"Analyze-\u003EAnalytics Projects"}],"ARM Case Number":"TS011708328","Platform":[{"code":"PF088","label":"Red Hat OpenShift"}],"Version":"4.5.3"}]
To view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
IBM Cloud Pak for Data
Component:
Analyze->Analytics Projects
Software version:
4.5.3
Operating system(s):
Red Hat OpenShift
Document number:
6853631
Modified date:
09 January 2023
UID
ibm16853631
Manage My Notification Subscriptions