[DRILL-2408] CTAS should not create empty folders when underlying query returns no results

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 1.0.0
• Component/s: Storage - Writer
• Assignee: Aman Sinha
• Reporter: Aman Sinha
• Created: 09/Mar/15 22:14
• Updated: 08/May/15 20:35
• Resolved: 07/May/15 21:26

Description

0: jdbc:drill:schema=dfs> select c_integer, c_bigint, c_date, c_time, c_varchar from j4 where c_bigint is null;
+------------+------------+------------+------------+------------+
| c_integer  |  c_bigint  |   c_date   |   c_time   | c_varchar  |
+------------+------------+------------+------------+------------+
+------------+------------+------------+------------+------------+
No rows selected (0.126 seconds)
0: jdbc:drill:schema=dfs> create table ctas_t6(c1,c2,c3,c4,c5) as select c_integer, c_bigint, c_date, c_time, c_varchar from j4 where c_bigint is null;
+------------+---------------------------+
|  Fragment  | Number of records written |
+------------+---------------------------+
| 0_0        | 0                         |
+------------+---------------------------+
1 row selected (0.214 seconds)
0: jdbc:drill:schema=dfs> select * from ctas_t6;
Query failed: IndexOutOfBoundsException: Index: 0, Size: 0

Error: exception while executing query: Failure while executing query. (state=,code=0)

parquet file was not created, but directory was:

[Mon Apr 06 09:03:41 root@/mapr/vmarkman.cluster.com/drill/testdata/joins/ctas_t6 ] # pwd
/mapr/vmarkman.cluster.com/drill/testdata/joins/ctas_t6
[Mon Apr 06 09:03:45 root@/mapr/vmarkman.cluster.com/drill/testdata/joins/ctas_t6 ] # ls -l
total 0

Issue Links

• is duplicated by: DRILL-2410 CTAS has issues when the underlying query returns 0 results