incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Krystal Nguyen <kngu...@maprtech.com>
Subject Re: Drill ODBC conenctor
Date Tue, 25 Nov 2014 23:58:56 GMT
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          |
> >> > +------------+
> >> >
> >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message