[jira] [Resolved] (DRILL-2612) Union All involving empty JSON file on right input to union all returns zero results

["Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-2612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sean Hsuan-Yi Chu resolved DRILL-2612.
--------------------------------------
    Resolution: Fixed

> Union All involving empty JSON file on right input to union all returns zero results
> ------------------------------------------------------------------------------------
>
>                 Key: DRILL-2612
>                 URL: https://issues.apache.org/jira/browse/DRILL-2612
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 0.9.0
>         Environment: | 9d92b8e319f2d46e8659d903d355450e15946533 | DRILL-2580: Exit early from HashJoinBatch if build side is empty | 26.03.2015 @ 16:13:53 EDT | Unknown     | 26.03.2015 @ 16:53:21 EDT |
>            Reporter: Khurram Faraaz
>            Assignee: Sean Hsuan-Yi Chu
>         Attachments: DRILL-2612.1.patch
>
>
> Union All returns zero results when the input JSON file on the right of union all operator is empty. 
> The JSON file to the left of Union All has data in it. Performing a Union All on such a setup results in zero results being returned by Union All.
> {code}
> 0: jdbc:drill:> select key from `intData.json` union all select key from `empty01.json`;
> +--+
> |  |
> +--+
> +--+
> No rows selected (0.092 seconds)
> File on the left of union all has 200 JSON objects in it.
> 0: jdbc:drill:> select count(key) from `intData.json`;
> +------------+
> |   EXPR$0   |
> +------------+
> | 200        |
> +------------+
> 1 row selected (0.073 seconds)
> 0: jdbc:drill:> select count(key) from `empty01.json`;
> +--+
> |  |
> +--+
> +--+
> No rows selected (0.074 seconds)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)