Rahul Challapalli created DRILL-2410:
----------------------------------------
Summary: 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)