Aman Sinha created DRILL-7391:
---------------------------------
Summary: Wrong result when doing left outer join on CSV table
Key: DRILL-7391
URL: https://issues.apache.org/jira/browse/DRILL-7391
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 1.16.0
Reporter: Aman Sinha
Assignee: Aman Sinha
Fix For: 1.17.0
The following query shows 1 row that is incorrect. For the non-null rows, both
columns should have the same value. This is on CSV sample data (I will attach
the files).
{noformat}
apache drill (dfs.tmp)> select tt5.columns[0], tt6.columns[0] from tt5 left
outer join tt6 on tt5.columns[0] = tt6.columns[0];
+--------+--------+
| EXPR$0 | EXPR$1 |
+--------+--------+
| 455 | null |
| 455 | null |
| 555 | null |
| 1414 | 1414 |
| 455 | null |
| 580 | null |
| 1111 | null |
| 555 | null |
| 455 | null |
| 455 | null |
| 455 | null |
| 455 | null |
| 455 | null |
| 555 | null |
| 455 | null |
| 455 | null |
| 455 | null |
| 580 | null |
| 6767 | null |
| 455 | null |
| 555 | null |
| 455 | null |
| 555 | null |
| 555 | null |
| 555 | null |
| 455 | null |
| 555 | null |
| 455 | null |
| 455 | null |
| 455 | null |
| 6767 | null |
| 555 | null |
| 555 | null |
| 455 | null |
| 555 | null |
| 555 | null |
| 1414 | 1414 |
| 455 | null |
| 555 | null |
| 555 | null |
| 455 | null |
| 455 | null |
| 555 | null |
| 455 | null |
| 555 | null |
| 555 | null |
| 455 | null |
| 455 | null |
| 9669 | 1414 | <--- Wrong result
| 555 | null |
| 455 | null |
| 455 | null |
| 455 | null |
| 555 | null |
| 580 | null |
| 455 | null |
| 555 | null |
| 455 | null |
| 555 | null |
| 455 | null |
| 455 | null |
| 409 | null |
| 455 | null |
| 555 | null |
| 555 | null |
| 455 | null |
| 455 | null |
| 555 | null |
| 455 | null |
| 555 | null |
| 1414 | 1414 |
| 455 | null |
| 555 | null |
| 555 | null |
| 555 | null |
+--------+--------+
75 rows selected
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
