[
https://issues.apache.org/jira/browse/DRILL-2612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14490548#comment-14490548
]
Sean Hsuan-Yi Chu commented on DRILL-2612:
------------------------------------------
Review done at:
https://reviews.apache.org/r/32634/
Commit#: 093626e33671510eb3952a09f6fefcb33bc90f18
> 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)
