[ https://issues.apache.org/jira/browse/DRILL-2223?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15199393#comment-15199393 ]
Khurram Faraaz commented on DRILL-2223: --------------------------------------- Like @amansinha100 said, this should at least write the schema information and metadata which will allow queries to run. I believe that is the correct approach to solve this problem. > Empty parquet file created with Limit 0 query errors out when querying > ---------------------------------------------------------------------- > > Key: DRILL-2223 > URL: https://issues.apache.org/jira/browse/DRILL-2223 > Project: Apache Drill > Issue Type: Bug > Components: Storage - Parquet > Affects Versions: 0.7.0 > Reporter: Aman Sinha > Fix For: Future > > > 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. > {code} > 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) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)