Hi, Using Drill 1.5, 13 nodes (6 cores each, Max Dir. Mem: 32GB, Max Heap 8 GB).
Sometime our CTAS queries gets "stuck". It runs for few hours or days and in the Fragment profiles graph, we see that the query is waiting on a single fragment ( for what appears to be a single horizontal line in the graph ). When this happens, if we hit CTL-C on the console that initiated the query, everything returns normally and the expected table is created and valid. Once when the query seemed stuck after 1 day, we let it go, and after 5 days it returned. We see this behavior with a query returning 0, 1 or millions of row. There was a post on this last year, I I can't find how or if the issue was resolved: http://mail-archives.apache.org/mod_mbox/drill-user/201505.mbox/%[email protected]%3E Francois
