What does the log says when the drillbit stops? Tim
On Tue, Nov 18, 2014 at 9:11 AM, lapro1 <[email protected]> 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
