[ https://issues.apache.org/jira/browse/HIVE-25275?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17367953#comment-17367953 ]
Stamatis Zampetakis commented on HIVE-25275: -------------------------------------------- Copying here some of the findings from the internal case. The problem seems to be a combination of two, three optimizer rules that lead to an expression getting bigger and bigger, leading to an infinite loop of rule matching in the {{HepPlanner}}. The following two rules seem to be the root of the problem: * HiveJoinPushTransitivePredicatesRule * HiveFilterProjectTransposeRule > OOM during query planning due to HiveJoinPushTransitivePredicatesRule > matching infinitely > ----------------------------------------------------------------------------------------- > > Key: HIVE-25275 > URL: https://issues.apache.org/jira/browse/HIVE-25275 > Project: Hive > Issue Type: Bug > Reporter: László Pintér > Priority: Major > > While running the following query OOM is raised during the planning phase > {code:sql} > CREATE TABLE A (`value_date` date) STORED AS ORC; > CREATE TABLE B (`business_date` date) STORED AS ORC; > SELECT A.VALUE_DATE > FROM A, B > WHERE A.VALUE_DATE = BUSINESS_DATE > AND A.VALUE_DATE = TRUNC(BUSINESS_DATE, 'MONTH'); > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)