[ https://issues.apache.org/jira/browse/DRILL-4249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15085941#comment-15085941 ]
Rahul Challapalli commented on DRILL-4249: ------------------------------------------ This could be failing during the planning state. It is possible that there is a specific timeout and until we wait for that specific time, drill might not throw any error or write anything in the logs. Did you wait long (~10 mins) enough before checking the logs? > 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 > {noformat} > 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 > {noformat} > {noformat} > 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; > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)