[
https://issues.apache.org/jira/browse/DRILL-6217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16392807#comment-16392807
]
ASF GitHub Bot commented on DRILL-6217:
---------------------------------------
Github user arina-ielchiieva commented on the issue:
https://github.com/apache/drill/pull/1154
+1, thanks for making the changes.
> NaN/Inf: NestedLoopJoin processes NaN values incorrectly
> --------------------------------------------------------
>
> Key: DRILL-6217
> URL: https://issues.apache.org/jira/browse/DRILL-6217
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.12.0
> Reporter: Volodymyr Tkach
> Assignee: Volodymyr Tkach
> Priority: Major
> Labels: ready-to-commit
> Fix For: 1.14.0
>
> Attachments: ObjsX.json
>
>
> *AFFECTED_FUNCTIONALITY:* INNER JOIN (nestedloopjoin)
> *ISSUE_DESCRIPTION:* according to *nestedloopjoin* query result NaN != NaN,
> however hashjoin / mergejoin behaves another way - NaN = NaN. As far as I
> understand, nestedloopjoin should behave like hashjoin / mergejoin. *STEPS*:
> - Upload the attached file to Hadoop fs (ObjsX.json);
> - Setup the following system settings:
> *set planner.enable_nljoin_for_scalar_only = false*
> *set planner.enable_hashjoin = false*
> *set planner.enable_mergejoin = false*
> *set planner.enable_nestedloopjoin = true*
> - Run the following sql query {code} select distinct t.name from
> dfs.tmp.`ObjsX.json` t inner join dfs.tmp.`ObjsX.json` tt on t.attr4 =
> tt.attr4 {code}
> *EXPECTED_RESULT:* It was expected to get the following result:
> {code}
> object1
> object2
> object3
> object4
> {code}
>
> *ACTUAL_RESULT:* The actual result is:
> {code}
> object2
> object3
> object4
> {code}
> Please investigate and fix
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
