drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Li HM <hmx...@gmail.com>
Subject Re: Drill ODBC conenctor
Date Tue, 25 Nov 2014 23:31:48 GMT
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
View raw message