[
https://issues.apache.org/jira/browse/DRILL-3023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14539271#comment-14539271
]
Murtaza commented on DRILL-3023:
--------------------------------
Hi Parth,
Please find the below step by step details on what I did -
1. Downloaded Apache drill from website and using URL =>
http://getdrill.org/drill/download/apache-drill-0.9.0.tar.gz
2. Downloaded Apache Drill ODBC driver using URL =>
http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.09.0.0620/MapRDrillODBC32.msi
http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.09.0.0620/MapRDrillODBC64.msi
3. Install latest JDK version 1.7 on CentOS linux and confirmed it by typing -
"java -version"
4. Untar apache-drill-0.9 on centos and executed below command to start Apache
drill
[root@kwtprdmsap001 apache-drill-0.9.0]# bin/sqlline -u jdbc:drill:zk=local
May 11, 2015 8:26:53 AM org.glassfish.jersey.server.ApplicationHandler
initialize
INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 01:25:26...
sqlline version 1.1.6
0: jdbc:drill:zk=local>
It started successfully and I could also check the Apache drill web console on
http://kwtprdmsap001:8047
5. I installed 32 bit and 64 bit both ODBC drivers on my Windows 7 machine
which is on the LAN network. I checked if DNS name kwtprdmsap001 can be
resolved and it was giving me correct IP address. After installation, I went to
ODBC32 Administrator as attached in the screenshot (attached in this JIRA).
Please let me know what is wrong with the configuration?
> Drill ODBC Connection not working - attached logs in the details
> ----------------------------------------------------------------
>
> Key: DRILL-3023
> URL: https://issues.apache.org/jira/browse/DRILL-3023
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - ODBC
> Affects Versions: 0.9.0
> Reporter: Murtaza
> Assignee: Parth Chandra
> Priority: Critical
>
> Getting below error in the sqlline log file.
> Apache Drill 0.9 is installed on CentOS 64bit, embedded drillbits. Trying to
> access ODBC from Windows machine after installing ODBC 32bit & 64bit drivers,
> both have same errors.
> 2015-05-11 14:47:29,652 [UserServer-1] ERROR
> o.a.drill.exec.rpc.user.UserServer - Error
> 2845b981-804a-44d4-a9f1-88866f778c26 in Handling handshake request:
> RPC_VERSION_MISMATCH, Invalid rpc version. Expected 5, actual 3.
> 2015-05-11 14:47:29,653 [UserServer-1] ERROR
> o.a.d.exec.rpc.RpcExceptionHandler - Exception in pipeline. Closing channel
> between local /172.16.98.101:31010 and remote /10.16.17.114:61346
> io.netty.handler.codec.DecoderException:
> org.apache.drill.exec.rpc.RpcException: Handshake request failed: Invalid rpc
> version. Expected 5, actual 3.
> at
> io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:99)
> [netty-codec-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
> [netty-codec-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:161)
> [netty-codec-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:787)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:130)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:116)
> [netty-common-4.0.24.Final.jar:4.0.24.Final]
> at java.lang.Thread.run(Thread.java:745) [na:1.7.0_60]
> Caused by: org.apache.drill.exec.rpc.RpcException: Handshake request failed:
> Invalid rpc version. Expected 5, actual 3.
> at
> org.apache.drill.exec.rpc.user.UserServer$1.consumeHandshake(UserServer.java:181)
> ~[drill-java-exec-0.9.0-rebuffed.jar:0.9.0]
> at
> org.apache.drill.exec.rpc.user.UserServer$1.consumeHandshake(UserServer.java:171)
> ~[drill-java-exec-0.9.0-rebuffed.jar:0.9.0]
> at
> org.apache.drill.exec.rpc.AbstractHandshakeHandler.decode(AbstractHandshakeHandler.java:57)
> ~[drill-java-exec-0.9.0-rebuffed.jar:0.9.0]
> at
> org.apache.drill.exec.rpc.AbstractHandshakeHandler.decode(AbstractHandshakeHandler.java:29)
> ~[drill-java-exec-0.9.0-rebuffed.jar:0.9.0]
> at
> io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89)
> [netty-codec-4.0.24.Final.jar:4.0.24.Final]
> ... 19 common frames omitted
> 2015-05-11 14:47:29,653 [UserServer-1] INFO
> o.a.drill.exec.rpc.user.UserServer - Channel closed between local
> /172.16.98.101:31010 and remote /10.16.17.114:61346
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
