[
https://issues.apache.org/jira/browse/HIVE-11234?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14626816#comment-14626816
]
Jesus Camacho Rodriguez commented on HIVE-11234:
------------------------------------------------
[~pxiong], I have been checking the patch, and in fact the method
{{isCombinablePredicate}} needs to be revisited; when it was created, it only
supported merging binary joins, while now we should be able to support merging
HiveJoin and HiveMultiJoin operators too. In fact, the method should have been
updated with HIVE-10533, but I didn't realize at the time. Do you mind that I
take over this issue and update the method accordingly?
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)
