[DRILL-2838] Applying flatten after joining 2 sub-queries returns empty maps

• Type: Bug
• Status: In Progress
• Priority: Critical
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Execution - Relational Operators
• Assignee: Jason Altekruse
• Reporter: Rahul Kumar Challapalli
• Created: 21/Apr/15 17:34
• Updated: 24/Jun/16 21:50

Description

git.commit.id.abbrev=5cd36c5

The below query applies flatten after joining 2 subqueries. It generates empty maps which is wrong

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)

I attached the data set. Let me know if you have any questions.

Issue Links

• is duplicated by: DRILL-2167 Order by on a repeated index from the output of a flatten on large no of records results in incorrect results
• is related to: DRILL-2167 Order by on a repeated index from the output of a flatten on large no of records results in incorrect results