HIVE-28532 Map Join Reuse cache allows to share hashtables for different join types

[ramesh0201]

What changes were proposed in this pull request?

Map join container cache key should be unique for each map join hash table if they are of different join types. This will prevent hash table from getting shared between different join types.

Why are the changes needed?

Sharing same hash table between different join types will not work because they expect different hash table type based on the join type. Otherwise we might run into ClassCastException and also potential wrong results in certain cases.

Does this PR introduce any user-facing change?

No

Is the change a dependency upgrade?

No

How was this patch tested?

cd ql mvn test -Dtest=TestSharedWorkOptimizer#testMapJoinCacheReuse

[sonarqubecloud[bot]]

Quality Gate passed

Issues
5 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud

[deniskuzZ]

@kasakrisz, do you know if there is anything left here? could this be merged?

[sonarqubecloud[bot]]

Quality Gate passed

Issues
5 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarQube Cloud