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

["Stamatis Zampetakis (Jira)" <ji...@apache.org>]

Stamatis Zampetakis created HIVE-24600:
------------------------------------------

             Summary: Strict type checks are not enforced on join conditions when CBO disabled
                 Key: HIVE-24600
                 URL: https://issues.apache.org/jira/browse/HIVE-24600
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
            Reporter: Stamatis Zampetakis
            Assignee: Stamatis Zampetakis


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.

{code:sql}
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;
{code}

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



--
This message was sent by Atlassian Jira
(v8.3.4#803005)