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":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"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"}]
Log InLog in 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 Log in button above to access the full document. 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
Modified date:
09 January 2023
UID
ibm16853631