You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Chinna Rao Lalam (Jira)" <ji...@apache.org> on 2020/01/09 07:16:00 UTC
[jira] [Commented] (HIVE-22710) When set CBO on, CalcitePlanner
genOPTree will be Out Of Memory
[ https://issues.apache.org/jira/browse/HIVE-22710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17011498#comment-17011498 ]
Chinna Rao Lalam commented on HIVE-22710:
-----------------------------------------
Hi [~jcamachorodriguez],
We encountered this issue and when analyzing we come across these issues CALCITE-2883 And HIVE-21365. Do you think still OOM problem is there in HepPlanner of CALCITE. Please throw some insights about this issue.
> When set CBO on, CalcitePlanner genOPTree will be Out Of Memory
> ---------------------------------------------------------------
>
> Key: HIVE-22710
> URL: https://issues.apache.org/jira/browse/HIVE-22710
> Project: Hive
> Issue Type: Bug
> Affects Versions: 3.1.0, 3.1.2
> Reporter: LuGuangMing
> Priority: Major
> Attachments: error_stack.log, sample.sql
>
>
> When set hive.cbo.enable=true, and execute a SQL contains union all and join to insert the result into three tables. Outofmemoryerror will appear in the compilation phase. For detailed SQL statements and error logs, please refer to the attachment. The same problem exists in hive 4.0.0
--
This message was sent by Atlassian Jira
(v8.3.4#803005)