You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2015/04/21 19:34:59 UTC
[jira] [Created] (DRILL-2838) Applying flatten after joining 2
sub-queries returns empty maps
Rahul Challapalli created DRILL-2838:
----------------------------------------
Summary: Applying flatten after joining 2 sub-queries returns empty maps
Key: DRILL-2838
URL: https://issues.apache.org/jira/browse/DRILL-2838
Project: Apache Drill
Issue Type: Bug
Components: Execution - Relational Operators
Reporter: Rahul Challapalli
Assignee: Chris Westin
Priority: Critical
Attachments: data.json
git.commit.id.abbrev=5cd36c5
The below query applies flatten after joining 2 subqueries. It generates empty maps which is wrong
{code}
select v1.uid, flatten(events), flatten(transactions) from
(select uid, events from `data.json`) v1
inner join
(select uid, transactions from `data.json`) v2
on v1.uid = v2.uid;
+------------+------------+------------+
| uid | EXPR$1 | EXPR$2 |
+------------+------------+------------+
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 1 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
| 2 | {} | {} |
+------------+------------+------------+
36 rows selected (0.244 seconds)
{code}
I attached the data set. Let me know if you have any questions.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)