[
https://issues.apache.org/jira/browse/DRILL-2408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14493316#comment-14493316
]
Rahul Challapalli commented on DRILL-2408:
------------------------------------------
[~amansinha100]
CTAS operations could be part of a daily workflow job. On some days these
queries might return empty results. If we do not create empty tables (with
empty parquet files), any subsequent automated jobs which query this table
would fail. Thoughts?
> CTAS should not create empty folders when underlying query returns no results
> -----------------------------------------------------------------------------
>
> Key: DRILL-2408
> URL: https://issues.apache.org/jira/browse/DRILL-2408
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Writer
> Affects Versions: 0.8.0
> Reporter: Aman Sinha
> Assignee: Deneche A. Hakim
> Priority: Critical
> Fix For: 0.9.0
>
> Attachments: DRILL-2408.1.patch.txt, DRILL-2408.2.patch.txt,
> DRILL-2408.3.patch.txt
>
>
> {noformat}
> 0: jdbc:drill:schema=dfs> select c_integer, c_bigint, c_date, c_time,
> c_varchar from j4 where c_bigint is null;
> +------------+------------+------------+------------+------------+
> | c_integer | c_bigint | c_date | c_time | c_varchar |
> +------------+------------+------------+------------+------------+
> +------------+------------+------------+------------+------------+
> No rows selected (0.126 seconds)
> 0: jdbc:drill:schema=dfs> create table ctas_t6(c1,c2,c3,c4,c5) as select
> c_integer, c_bigint, c_date, c_time, c_varchar from j4 where c_bigint is null;
> +------------+---------------------------+
> | Fragment | Number of records written |
> +------------+---------------------------+
> | 0_0 | 0 |
> +------------+---------------------------+
> 1 row selected (0.214 seconds)
> 0: jdbc:drill:schema=dfs> select * from ctas_t6;
> Query failed: IndexOutOfBoundsException: Index: 0, Size: 0
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> {noformat}
> parquet file was not created, but directory was:
> {noformat}
> [Mon Apr 06 09:03:41
> root@/mapr/vmarkman.cluster.com/drill/testdata/joins/ctas_t6 ] # pwd
> /mapr/vmarkman.cluster.com/drill/testdata/joins/ctas_t6
> [Mon Apr 06 09:03:45
> root@/mapr/vmarkman.cluster.com/drill/testdata/joins/ctas_t6 ] # ls -l
> total 0
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
