[ 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)