[DRILL-3249] CTAS from an empty TSV file fails

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 1.0.0
• Fix Version/s: 1.14.0
• Component/s: Storage - Text & CSV
• Labels: csv
• Assignee: Vitalii Diravka
• Reporter: Stuart Hayes
• Created: 03/Jun/15 16:04
• Updated: 06/Dec/18 18:02
• Resolved: 06/Dec/18 18:02

Description

Performing a CTAS to parquet from an empty CSV file fails:

CREATE TABLE dfs.latest.d_csi(dsa_id, uid, DN, d_csi_name, d_svc_avail, d_sending_opt, d_supp_cap_ph, d_repl_hndl_lup, d_repl_hnd_interr, d_opt_routing, ref_status) AS
SELECT cast(columns[0] AS INTEGER), columns[1], columns[2], columns[3], columns[4], columns[5], columns[6], columns[7], columns[8], columns[9], columns[10] FROM dfs.converted.`02062015/25/d_csi.txt`;

Error: SYSTEM ERROR: java.lang.IllegalArgumentException: MinorFragmentId 0 has no read entries assigned

This is part of a daily automated job in which case the entire job fails. An empty file/table should be a valid scenario.