You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Arina Ielchiieva (Jira)" <ji...@apache.org> on 2019/11/04 15:19:00 UTC
[jira] [Updated] (DRILL-7391) Wrong result when doing left outer
join on CSV table
[ https://issues.apache.org/jira/browse/DRILL-7391?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva updated DRILL-7391:
------------------------------------
Reviewer: Igor Guzenko
> 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: Vova Vysotskyi
> Priority: Major
> Fix For: 1.17.0
>
> Attachments: tt5.tar.gz, tt6.tar.gz
>
>
> 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)