incubator-drill-user mailing list archives

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