Mailing-List: contact drill-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: drill-user@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of jbates@maprtech.com designates
 209.85.213.47 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAEYhXbUTHmT7MCRzwQ6rc4_fVzJkz=dby6LovkVZfn65G7_Qdw@mail.gmail.com>
References: 
 <CAMA9Zyq0FODx_1R2xdKR_AsrVVf1tfjOtu6T2bCiB1OYKQ4OoA@mail.gmail.com>
 <CAEYhXbUpOPnuoB8WwneVYxbqM7kxv2CkcmDzxBD05orcihW0dQ@mail.gmail.com>
 <CAMA9Zypuph8kYDUfvKDrXFrSeQSXsgz=FWqdH-jqkbBSYD7xGQ@mail.gmail.com>
 <CAEYhXbWn-XQ2C8FMsNL2yvzTJeqapJ1XFhWhZr=cqEF6VSZ0Vg@mail.gmail.com>
 <CAMA9ZyoGUaBmU7EtNT4p8JtAKQT-kxzsSBxrsyW9a9ELvs7YfA@mail.gmail.com>
 <CAEYhXbUTHmT7MCRzwQ6rc4_fVzJkz=dby6LovkVZfn65G7_Qdw@mail.gmail.com>
From: Jim Bates <jbates@maprtech.com>
Date: Tue, 25 Nov 2014 20:04:34 -0600
Message-ID: 
 <CAA-=08FubsU9MpxkBD1NMbBDpYvfu-GX88C+mqC06_hXgzpg4g@mail.gmail.com>
Subject: Re: Drill ODBC conenctor
To: Drill-User <drill-user@incubator.apache.org>
Cc: Krystal Nguyen <knguyen@maprtech.com>
Content-Type: multipart/alternative; boundary=001a1139199a3432d90508b974a7

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

FYI: I was having trouble getting the latest version (0.07.00.608) to work
with Tableau in Amazon EC2. Drill Explorer was working but Tableau could
not connect with the same system DSN(Just became non-responsive on
connect). I removed the DSN created during install and re-added it again
and the problem was resolved.

On Tue, Nov 25, 2014 at 6:11 PM, Li HM <hmxxyy@gmail.com> wrote:

> fc58c693ae0cd9234e5e62a7602b4cc216b8549d
>
>
> https://github.com/apache/incubator-drill/commit/fc58c693ae0cd9234e5e62a7602b4cc216b8549d
>
> This is the snapshot I got at Nov. 20th.
>
> On Tue, Nov 25, 2014 at 3:58 PM, Krystal Nguyen <knguyen@maprtech.com>
> wrote:
> > Is your drillbits the latest?  Can you give me the value for
> git.commit.id
> > from git.properties file.   The new odbc driver only works with the
> latest
> > drillbits.
> >
> > Thanks,
> > Krystal
> >
> > On Tue, Nov 25, 2014 at 3:31 PM, Li HM <hmxxyy@gmail.com> wrote:
> >>
> >> yes. they are pingable.
> >>
> >> I've also checked all related ports 31010, 31011, 31012, they are all
> >> open to the host which I run the iODBC.
> >>
> >> On Tue, Nov 25, 2014 at 11:50 AM, Krystal Nguyen <knguyen@maprtech.com>
> >> wrote:
> >> > From the Mac, can you ping your cluster using the hostname?
> >> >
> >> > On Tue, Nov 25, 2014 at 11:47 AM, Li HM <hmxxyy@gmail.com> wrote:
> >> >>
> >> >> no. i am not using MapR sandbox.
> >> >>
> >> >> it is a test cluster with two nodes running drill built from the git
> >> >> master.
> >> >>
> >> >> On Tue, Nov 25, 2014 at 10:47 AM, Krystal Nguyen <
> knguyen@maprtech.com>
> >> >> wrote:
> >> >> > Hi Li,
> >> >> >
> >> >> > Are you using the MapR SandBox?  If so, have you add the host name
> >> >> > resolution of the SandBox in /etc/hosts on the mac.
> >> >> >
> >> >> > Thanks,
> >> >> > Krystal
> >> >> >
> >> >> > ---------- Forwarded message ----------
> >> >> > From: Li HM <hmxxyy@gmail.com>
> >> >> > Date: Monday, November 24, 2014
> >> >> > Subject: Drill ODBC conenctor
> >> >> > To: sollala@maprtech.com, "drill-user@incubator.apache.org"
> >> >> > <drill-user@incubator.apache.org>
> >> >> >
> >> >> >
> >> >> > 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          |
> >> >> > +------------+
> >> >> >
> >> >
> >> >
> >
> >
>

--001a1139199a3432d90508b974a7--