Mailing-List: contact drill-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: drill-user@incubator.apache.org
Received-SPF: pass (athena.apache.org: domain of cmatta@maprtech.com
 designates 74.125.82.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAEYhXbXv+C1xj5uVW=s8J-kLAH9o5Z8cAqRrDTWpy6RzJ+rYxA@mail.gmail.com>
References: 
 <CAA-=08GopFzAjn9RM_HtAEOeic1wnx86d4eXVm51ADJN4Gor5w@mail.gmail.com>
	<CAKa9qDkGJW-6ofZ3e-Z9bDnDfoj6qjrdo4TVGtiW5gkykRp8OA@mail.gmail.com>
	<CAE9Z48od9dqMxEM-Ro3rwgDM0Zq=SRNV621mETMm12vTc-3bHA@mail.gmail.com>
	<CAE9Z48oAcde9KQwu_vHkDSvPg3RgkpW9RCvTyxpoRKMMMPGQag@mail.gmail.com>
	<724A5FF2-BFDE-4D5A-A1BB-C364CB7595F8@gmail.com>
	<CALWzRJDsKBFd9VWgDfm0Uvd3qMahLejNKHy1pWRWtKvgjR5v0g@mail.gmail.com>
	<loom.20141120T035737-777@post.gmane.org>
	<BC8440DF-24E5-4650-A64E-6ED826E2F617@gmail.com>
	<CALWzRJBCahQXGFX3R2+-ELnr0081XHZVrrTeyq2wNeZfg97mtQ@mail.gmail.com>
	<CAEYhXbXpkFkz+PtSDKD=ZSKD1gERhgZkfyHzMxT6dV1n2ME3pg@mail.gmail.com>
	<CALWzRJDE8eZvusdLEXCy0wOUnwzFPC+e4+m4k0Bq0XDYeA1szA@mail.gmail.com>
	<CALWzRJBZeZc50PHc0D-+GVi5bfdsZ7+xQdk4vEzEex-_7uYTMA@mail.gmail.com>
	<CAEYhXbXv+C1xj5uVW=s8J-kLAH9o5Z8cAqRrDTWpy6RzJ+rYxA@mail.gmail.com>
Date: Tue, 25 Nov 2014 08:44:18 -0500
Message-ID: 
 <CAJ=5R7Xfv1=3j0o5gaGHeZ8hAFVaJDwe_bfM=of=6Ji18uKY5A@mail.gmail.com>
Subject: Re: Drill ODBC conenctor
From: Christopher Matta <cmatta@mapr.com>
To: "drill-user@incubator.apache.org" <drill-user@incubator.apache.org>
Cc: "sollala@maprtech.com" <sollala@maprtech.com>
Content-Type: multipart/alternative; boundary=f46d044306429c70ee0508af1be9

--f46d044306429c70ee0508af1be9
Content-Type: text/plain; charset=UTF-8

It would be helpful to have the version and the build number included in
the ODBC installer file's name.

On Tuesday, November 25, 2014, Li HM <hmxxyy@gmail.com> wrote:

> Thanks for the update.
>
> Just tried the Mac version, doesn't seem to work.
>
> I am using iodbc to do the test
>
> SQL>select id from hiveremote.lih.test
>
> 1: SQLPrepare = [MapR][Drill] (1050) Query timed out
> (QueryTimeout=180): [30023]Timed out waiting for server to respond.
> (1050) SQLSTATE=HY000
>
> The query shown on the localhost:8048 is:
> SELECT * FROM (select id from hiveremote.lih.test) T LIMIT 0
>
> in the drillbit.log
> it has one line
> 2014-11-25 07:05:47,607 [UserServer-1] INFO
> o.a.drill.exec.rpc.user.UserServer - Channel closed between local
> 0.0.0.0/0.0.0.0:31010 and remote /98.138.236.95:49115
>
> from sqlline, the same query returns
> 0: jdbc:drill:> select id from hiveremote.lih.test;
> +------------+
> |     id     |
> +------------+
> | 1          |
> | 2          |
> | 3          |
> | 4          |
> | 5          |
> | 6          |
> | 7          |
> | 8          |
> | 9          |
> +------------+
>
> On Mon, Nov 24, 2014 at 5:17 PM, Suresh Ollala <sollala@maprtech.com
> <javascript:;>> wrote:
> > Updated ODBC drivers are now available for Windows, Linux and Mac
> >
> > http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc/
> >
> >
> >
> > On Thu, Nov 20, 2014 at 8:01 AM, Suresh Ollala <sollala@maprtech.com
> <javascript:;>> wrote:
> >
> >> It will be up there very soon.
> >>
> >> On Wed, Nov 19, 2014 at 10:29 PM, Li HM <hmxxyy@gmail.com
> <javascript:;>> wrote:
> >>
> >>> Thanks Suresh.
> >>>
> >>> Do you have a Mac version for master branch?
> >>>
> >>> I don't see a dmg file under
> >>> /tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc/
> >>>
> >>> On Wed, Nov 19, 2014 at 9:43 PM, Suresh Ollala <sollala@maprtech.com
> <javascript:;>>
> >>> wrote:
> >>> > For apache-drill 0.6.0 use -
> >>> >
> >>>
> http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v0.07.0.0600/
> >>> >
> >>> >
> >>> > For master branch of apache-drill, use -
> >>> > http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc/
> >>> >
> >>> > On Wed, Nov 19, 2014 at 8:27 PM, Hmxxyy <hmxxyy@gmail.com
> <javascript:;>> wrote:
> >>> >
> >>> >> Do you know if it works with the build from the master branch?
> >>> >>
> >>> >> Thanks.
> >>> >>
> >>> >> Sent from my iPhone
> >>> >>
> >>> >> > On Nov 19, 2014, at 7:07 PM, Leo Cook <leo_a_cook@yahoo.co.uk
> <javascript:;>>
> >>> wrote:
> >>> >> >
> >>> >> > Suresh Ollala <sollala@...> writes:
> >>> >> >
> >>> >> >>
> >>> >> >> MapR releases compatible ODBC driver with latest Drill master
> >>> >> frequently.
> >>> >> >> The latest one will be posted in next couple of days, I will
> reply
> >>> to
> >>> >> this
> >>> >> >> thread once new compatible ODBC driver is available.
> >>> >> >
> >>> >> >
> >>> >> > FYI
> >>> >> >
> >>> >> > I found that the windows MapR ODBC driver posted at
> >>> >> >
> >>> >> >
> http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc/
> >>> >> >
> >>> >> > only works with this drill package that MapR guys posted on 17th
> Nov
> >>> (and
> >>> >> > presumably the official trunk)
> >>> >> >
> >>> >> >
> >>> >>
> >>>
> http://package.mapr.com/drill/download/apache-drill-0.6.0.r2-incubating-SNAPSHOT.tar.gz
> >>> >> >
> >>> >> > Anything else fails with a conflict in rpc version as the obdc
> >>> driver is
> >>> >> at
> >>> >> > v3, drill 0.6.0 is at v2. There seems to be no available
> historical
> >>> >> versions
> >>> >> > of the MapR driver so you are forced to move ahead of 0.6.0 if you
> >>> want
> >>> >> > connectivity through ODBC. Please correct if wrong.
> >>> >> >
> >>> >> > Rgds
> >>> >> >
> >>> >> > Leo
> >>> >> >
> >>> >> >
> >>> >>
> >>>
> >>
> >>
>


-- 
Chris Matta
cmatta@mapr.com
215-701-3146

--f46d044306429c70ee0508af1be9--