[HIVE-24600] Strict type checks are not enforced on join conditions when CBO disabled

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Query Processor
• Target Version/s: 4.0.0
• Assignee: Stamatis Zampetakis
• Reporter: Stamatis Zampetakis
• Created: 07/Jan/21 10:14
• Updated: 07/Jan/21 12:24

Description

When hive.strict.checks.type.safety property is set to true, queries with unsafe comparisons should fail with an appropriate exception no matter if CBO is enabled or not (hive.cbo.enable).

At the moment the safety checks are not applied in join conditions present in the ON clause when CBO is disabled.

For example, both queries below should fail.

set hive.strict.checks.type.safety=true;
set hive.cbo.enable=false;
SELECT * FROM biginttbl INNER JOIN strtbl ON bigintcol=strcol;
SELECT * FROM biginttbl INNER JOIN strtbl WHERE bigintcol=strcol;

At the moment, the second query (with WHERE clause) will fail but not the first one (with ON clause).