Merge operation is not working as expected. During LEFT JOIN rows on the left side that do not present on the right side are being matched by null row on the right.

Description

In case of the LEFT JOIN if we have null values on the right frame in the column we are merging on we will get rows from the left frame that do not present on the right side matched with the null rows.

There is a brach that reproduces the case. Also screenshot of the test and printouts is attached. You can see that rows `c` and `e` were matched by null row.

Assignee

Wendy

Fix versions

Reporter

Andrey Spiridonov

Support ticket URL

None

Labels

None

Affected Spark version

None

Customer Request Type

None

Task progress

None

CustomerVisible

No

Components

Priority

Blocker
Configure