[jira] [Updated] (HIVE-10786) Propagate Histograms in Calcite/Physical Optimizer

["Laljo John Pullokkaran (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-10786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laljo John Pullokkaran updated HIVE-10786:
------------------------------------------
    Summary: Propagate Histograms in Calcite/Physical Optimizer  (was: Propagate range for column stats)

> Propagate Histograms in Calcite/Physical Optimizer
> --------------------------------------------------
>
>                 Key: HIVE-10786
>                 URL: https://issues.apache.org/jira/browse/HIVE-10786
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Pengcheng Xiong
>
> For column stats, Calcite doesn't propagate range. Range of a col will help us in deciding filter cardinality for inequality.
> Range of values of a column and NDV together will help us to get build histograms of uniform height.
> This needs special handling for each operator:
> - Inner Join where col is part of join key: range is lowest range of lhs, rhs
> - Outer Join: range of outer side if col is from outer side
> - Filter inequality on literal ("x<10"): Range is restricted on upper side by literal value



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)