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)