[
https://issues.apache.org/jira/browse/DRILL-2410?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rahul Challapalli resolved DRILL-2410.
--------------------------------------
Resolution: Duplicate
> CTAS has issues when the underlying query returns 0 results
> -----------------------------------------------------------
>
> Key: DRILL-2410
> URL: https://issues.apache.org/jira/browse/DRILL-2410
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Parquet
> Reporter: Rahul Challapalli
> Assignee: Steven Phillips
> Attachments: error.log
>
>
> git.commit.id.abbrev=e92db23
> The below CTAS statement succeeds. Here the query in CTAS returns 0 results.
> {code}
> create table empty_table as select columns[0] id from `rankings` where
> columns[0] < 0;
> {code}
> However when I try to run any queries on top of it drill reports a failure
> {code}
> 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)
> {code}
> Attached the error log file
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
