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

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

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)