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

["Vineet Garg (JIRA)" <ji...@apache.org>]

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

Vineet Garg edited comment on HIVE-21817 at 6/4/19 12:03 AM:
-------------------------------------------------------------

[~gopalv] I am running simple query from {{partition_pruning.q}} and I see {{public static PrunedPartitionList prune}} hitting the cache. Both of these are using same cache. Can you provide an example query where you observe cache miss?


was (Author: vgarg):
[~gopalv] I am running simple query from {{partition_pruning}} and I see {{public static PrunedPartitionList prune}} hitting the cache. Both of these are using same cache. Can you provide an example query where you observe cache miss?

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