[jira] [Commented] (HIVE-21817) CBO: PartitionPruner cache-miss from Calcite planner

["Gopal V (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-21817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16853526#comment-16853526 ] 

Gopal V commented on HIVE-21817:
--------------------------------

The cache-key for the 2nd one is 

{code}
    String key = tab.getFullyQualifiedName() + ";";
...
    key = key + compactExprString;
{code}

> CBO: PartitionPruner cache-miss from Calcite planner
> ----------------------------------------------------
>
>                 Key: HIVE-21817
>                 URL: https://issues.apache.org/jira/browse/HIVE-21817
>             Project: Hive
>          Issue Type: Bug
>          Components: CBO
>            Reporter: Gopal V
>            Assignee: Jesus Camacho Rodriguez
>            Priority: Major
>         Attachments: calcite-ppr.png
>
>
>  !calcite-ppr.png! 
> {code}
> public static PrunedPartitionList prune(Table tab, ExprNodeDesc prunerExpr,
>       HiveConf conf, String alias, Map<String, PrunedPartitionList> prunedPartitionsMap)
>           throws SemanticException {
> vs
>   public PrunedPartitionList getPrunedPartitions(String alias, TableScanOperator ts)
>       throws SemanticException {
>     PrunedPartitionList partsList = opToPartList.get(ts);
> {code}
> Only the 2nd one hits the PPR cache.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)