You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org> on 2019/02/07 21:25:00 UTC
[jira] [Created] (HIVE-21230) HiveJoinAddNotNullRule bails out for
outer joins
Jesus Camacho Rodriguez created HIVE-21230:
----------------------------------------------
Summary: HiveJoinAddNotNullRule bails out for outer joins
Key: HIVE-21230
URL: https://issues.apache.org/jira/browse/HIVE-21230
Project: Hive
Issue Type: Improvement
Components: CBO
Reporter: Jesus Camacho Rodriguez
For instance, given the following query:
{code:sql}
SELECT t0.col0, t0.col1
FROM
(
SELECT col0, col1 FROM tab
) AS t0
LEFT JOIN
(
SELECT col0, col1 FROM tab
) AS t1
ON t0.col0 = t1.col0 AND t0.col1 = t1.col1
{code}
we could still infer that col0 and col1 cannot be null in the right input and introduce the corresponding filter predicate. Currently, the rule just bails out if it is not an inner join.
https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveJoinAddNotNullRule.java#L79
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)