[
https://issues.apache.org/jira/browse/HIVE-24600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stamatis Zampetakis reassigned HIVE-24600:
------------------------------------------
> 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
> Priority: Major
>
> 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)
