drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4249) DROP TABLE HANGS indefinitely
Date Wed, 06 Jan 2016 10:29:39 GMT
Khurram Faraaz created DRILL-4249:

             Summary: DROP TABLE HANGS indefinitely
                 Key: DRILL-4249
                 URL: https://issues.apache.org/jira/browse/DRILL-4249
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Flow
    Affects Versions: 1.4.0
         Environment: 4 node cluster on CentOS
            Reporter: Khurram Faraaz

DROP TABLE hangs. Table was created using CTAS and the input to CTAS was a directory that
had 2000 JSON files.

There is no Exception or error message on sqlline prompt nor in drillbit.log

Drill 1.4.0, git commitID: 32b85160

hadoop fs -ls /tmp shows that the directory exists (at the time when DROP TABLE was hung)
drwxr-xr-x   - mapr mapr   10550677 2016-01-05 12:14 /tmp/tblMD332_wp

Snippet from drillbit.log, there's no further information after the below text in drillbit.log

2016-01-06 10:03:09,817 [297319a1-fb9d-8247-7d12-c8d551d56d2d:foreman] INFO  o.a.drill.exec.work.foreman.Foreman
- Query text for query id 297319a1-fb9d-8247-7d12-c8d551d56d2d: drop table tblMD332_wp
2016-01-06 10:03:11,516 [297319a1-fb9d-8247-7d12-c8d551d56d2d:foreman] INFO  o.a.d.exec.store.dfs.FileSelection
- FileSelection.create() took 6 ms
2016-01-06 10:03:11,517 [297319a1-fb9d-8247-7d12-c8d551d56d2d:foreman] INFO  o.a.d.exec.store.dfs.FileSelection
- FileSelection.getStatuses() took 0 ms, numFiles: 1

Note that DROP TABLE commands hangs indefinitely.
[root@centos-01 bin]# ./sqlline -u "jdbc:drill:schema=dfs.tmp -n mapr -p mapr"
apache drill 1.4.0
"got drill?"
0: jdbc:drill:schema=dfs.tmp> drop table tblMD332_wp;


This message was sent by Atlassian JIRA

View raw message