Khurram Faraaz created DRILL-2612: ------------------------------------- Summary: 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: Jinfeng Ni
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)