You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2019/11/04 15:14:00 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=16966737#comment-16966737 ]
ASF GitHub Bot commented on DRILL-7391:
---------------------------------------
vvysotskyi commented on pull request #1890: DRILL-7391: Wrong result when doing left outer join on CSV table
URL: https://github.com/apache/drill/pull/1890
Jira: [DRILL-7391](https://issues.apache.org/jira/browse/DRILL-7391).
Actual fixes were done in Calcite ([CALCITE-3390](https://issues.apache.org/jira/browse/CALCITE-3390), [CALCITE-3457](https://issues.apache.org/jira/browse/CALCITE-3457)), this PR just adds unit test and updates Calcite version to include these fixes.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
> 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)