[
https://issues.apache.org/jira/browse/HIVE-11234?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14626827#comment-14626827
]
Jesus Camacho Rodriguez commented on HIVE-11234:
------------------------------------------------
Sure, makes sense, I'll do that. Thanks
> CBO: Calcite Operator To Hive Operator (Calcite Return Path): reconsider the
> cross product in HiveJoinToMultiJoinRule
> ---------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-11234
> URL: https://issues.apache.org/jira/browse/HIVE-11234
> Project: Hive
> Issue Type: Sub-task
> Components: CBO
> Reporter: Pengcheng Xiong
> Assignee: Pengcheng Xiong
> Attachments: HIVE-11234.01.patch
>
>
> Cross product in HiveJoinToMultiJoinRule needs to be reconsidered. Now the
> following explain query will fail at L1116 StatsRulesProcFactory : FAILED:
> IndexOutOfBoundsException Index: 0, Size: 0 because the key in one of the
> branches of the join is empty.
> {code}
> explain select * from src
> where src.key not in (select key from src1);
> {code}
> If we run
> {code}
> select * from src
> where src.key not in (select key from src1);
> {code}
> we will have "FAILED: Execution Error, return code 2 from
> org.apache.hadoop.hive.ql.exec.mr.MapRedTask". The root cause is the same.
> Other queries that will also fail include cbo_subq_not_in.q etc.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
