[jira] [Resolved] (DRILL-2410) CTAS has issues when the underlying query returns 0 results

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

     [ 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)