incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From lapro1 <lap...@gmail.com>
Subject Drill stops immediately
Date Tue, 18 Nov 2014 17:11:25 GMT
Hi,
My drill does the following problem, and it's quite disturbing, because it
stops my job, and I have to wait for it for really long time.
Sometimes, if I create a table, or I'd like to query something, it stops
without any answer. I have to restart drillbit, but also this is very slow.
For example it takes about 15-20 minutes for.

[root@sandbox ~]# /opt/drill/bin/drillbit.sh stop
Drill log directory /var/log/drill does not exist, defaulting to
/opt/drill/log
stopping drillbit
.......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................force
stopping drillbit with kill -9 10790
[root@sandbox ~]#


I use drill over hadoop with only one datanode, because I'm a test user,
and my computer would be very slowly with more virtual machines. Is it
possible, that this couses the problem?

Last, when it stopped I gave it the command below:
0: jdbc:drill:zk=master:2181> create table nasadata(host, datetime,
request, response1, response2) as select columns[0] AS `host`, columns[1]
AS `datetime`, columns[2] AS `request`, columns[3] AS `response1`,
columns[4] AS `response2` from dfs.`/drill/datafiles/log_Aug.csv`;

Thanks the answer in advance.
Laszlo

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