[jira] [Created] (FLINK-14789) extends max/min type in ColumnStats from Number to Comparable

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (FLINK-14789) extends max/min type in ColumnStats from Number to Comparable

Shang Yuanchun (Jira)
godfrey he created FLINK-14789:
----------------------------------

             Summary: extends max/min type in ColumnStats from Number to Comparable
                 Key: FLINK-14789
                 URL: https://issues.apache.org/jira/browse/FLINK-14789
             Project: Flink
          Issue Type: Sub-task
          Components: Table SQL / Planner
            Reporter: godfrey he
             Fix For: 1.10.0


Many tpc-ds queries have predicates on date, like `d_date between '1999-02-01' and (cast('1999-02-01' as date) + INTERVAL '60' day)`, It's very useful to find a better plan if the planner knows the max/min values of date. However, max/min in {{ColumnStats}} only support {{Number}} type currently. This issue aims to extend max/min type from {{Number}} to {{Comparable}}, and then {{Date}}, {{Time}}, {{Timestamp}} even {{String}} could be supported.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)