[ 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)