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
