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

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.10.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: godfrey he
• Reporter: godfrey he
• Created: 14/Nov/19 14:00
• Updated: 19/Nov/19 03:26
• Resolved: 19/Nov/19 03:26

Description

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.

Issue Links

• links to: GitHub Pull Request #10196