drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2612) Union All involving empty JSON file on right input to union all returns zero results
Date Fri, 27 Mar 2015 22:04:53 GMT
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)

Mime
View raw message