[DRILL-2223] Empty parquet file created with Limit 0 query errors out when querying

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Fix Version/s: Future
• Component/s: Storage - Parquet
• Assignee: Unassigned
• Reporter: Aman Sinha
• Created: 12/Feb/15 07:47
• Updated: 29/Nov/16 08:10
• Resolved: 17/Mar/16 12:16

Description

Doing a CTAS with limit 0 creates a 0 length parquet file which errors out during querying. This should at least write the schema information and metadata which will allow queries to run.

0: jdbc:drill:zk=local> create table tt_nation2 as select n_nationkey, n_name, n_regionkey from cp.`tpch/nation.parquet` limit 0;
+------------+---------------------------+
|  Fragment  | Number of records written |
+------------+---------------------------+
| 0_0        | 0                         |
+------------+---------------------------+
1 row selected (0.315 seconds)
0: jdbc:drill:zk=local> select n_nationkey from tt_nation2;
Query failed: RuntimeException: file:/tmp/tt_nation2/0_0_0.parquet is not a Parquet file (too small)

Issue Links

• is duplicated by: DRILL-3635 IllegalArgumentException - not a Parquet file (too small)
• relates to: DRILL-4517 Reading emtpy Parquet file failes with java.lang.IllegalArgumentException