[DRILL-2410] CTAS has issues when the underlying query returns 0 results

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: Storage - Parquet
• Assignee: Steven Phillips
• Reporter: Rahul Kumar Challapalli
• Created: 09/Mar/15 23:08
• Updated: 20/Apr/15 22:15
• Resolved: 09/Mar/15 23:45

Description

git.commit.id.abbrev=e92db23

The below CTAS statement succeeds. Here the query in CTAS returns 0 results.

create table empty_table as select columns[0] id from `rankings` where columns[0] < 0;

However when I try to run any queries on top of it drill reports a failure

select * from temp1;
Query failed: RuntimeException: maprfs:/drill/empty_table/0_0_0.parquet is not a Parquet file (too small)

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

Attached the error log file

Issue Links

• duplicates: DRILL-2408 CTAS should not create empty folders when underlying query returns no results