drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Murtaza (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3023) Drill ODBC Connection not working - attached logs in the details
Date Tue, 12 May 2015 05:32:59 GMT

    [ 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)

Mime
View raw message