[
https://issues.apache.org/jira/browse/HIVE-13637?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15263859#comment-15263859
]
Jesus Camacho Rodriguez commented on HIVE-13637:
------------------------------------------------
I was also doubting... Problem is that Calcite does not support NVL natively,
so we might miss folding optimization opportunities if we convert CASE into
NVL. I could also create an additional rule to transform it at the end of query
planning, but it seems an overkill.
I have just uploaded a new patch that integrates the conversion in the parser
instead of the ASTConverter, and thus integrates better with the work done in
HIVE-13068 (it will need that patch to go in first though).
> Fold CASE into NVL when CBO optimized the plan
> ----------------------------------------------
>
> Key: HIVE-13637
> URL: https://issues.apache.org/jira/browse/HIVE-13637
> Project: Hive
> Issue Type: Sub-task
> Components: CBO
> Affects Versions: 2.1.0
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
> Attachments: HIVE-13637.patch, HIVE-13637.patch
>
>
> After HIVE-13068 goes in, folding CASE into NVL got disabled when CBO has
> optimized the plan, as it was done by ConstantPropagate in Hive. We need to
> enable it back.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
