incubator-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 Wed, 26 Nov 2014 00:11:09 GMT
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          |
>> >> > +------------+
>> >> >
>> >
>> >
>
>

Mime
View raw message