[
https://issues.apache.org/jira/browse/HIVE-10786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jesus Camacho Rodriguez updated HIVE-10786:
-------------------------------------------
Description:
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
was:
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
> Propagate range for column stats
> --------------------------------
>
> Key: HIVE-10786
> URL: https://issues.apache.org/jira/browse/HIVE-10786
> Project: Hive
> Issue Type: Bug
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
>
> 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)
