incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Timothy Chen <tnac...@gmail.com>
Subject Re: Drill stops immediately
Date Tue, 18 Nov 2014 19:44:15 GMT
What does the log says when the drillbit stops?

Tim

On Tue, Nov 18, 2014 at 9:11 AM, lapro1 <lapro1@gmail.com> wrote:
> 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
View raw message