[ https://issues.apache.org/jira/browse/HIVE-13068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15261863#comment-15261863 ]
Jesus Camacho Rodriguez commented on HIVE-13068: ------------------------------------------------ [~ashutoshc], I think patch is ready to review; probably I will need to update a few files when QA comes back. I extended current logic to cover major regressions, but I left four issues for the follow-up, as the patch was growing rather large and they seem independent extensions to this work: - Transform NVL to CASE (HIVE-13637). Regression can be seen in constantPropWhen.q - Rule to pull up constants through Limit (HIVE-13638). Regression can be seen in input26.q - Rule to pull up constants through Union (HIVE-13639). Regression can be seen in union_view.q - Bring PartitionConditionRemover to Calcite (HIVE-13640). Regression can be seen in index_auto_unused.q In turn, the extensions that I added to HiveRexUtil will be in Calcite 1.8.0 (CALCITE-1220), thus it will be removed once we upgrade to the newest Calcite version. > Disable Hive ConstantPropagate optimizer when CBO has optimized the plan II > --------------------------------------------------------------------------- > > Key: HIVE-13068 > URL: https://issues.apache.org/jira/browse/HIVE-13068 > Project: Hive > Issue Type: Sub-task > Components: CBO, Logical Optimizer > Affects Versions: 2.1.0 > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Attachments: HIVE-13068.01.patch, HIVE-13068.01.patch, > HIVE-13068.02.patch, HIVE-13068.patch > > > After HIVE-12543 went in, we need follow-up work to disable the last call to > ConstantPropagate in Hive. This probably implies work on extending the > constant folding logic in Calcite. -- This message was sent by Atlassian JIRA (v6.3.4#6332)