[FLINK-14079] Full data type support in planner

• Type: New Feature
• Status: Open
• Priority: Not a Priority
• Resolution: Unresolved
• Component/s: Table SQL / API
• Labels: auto-deprioritized-major auto-deprioritized-minor
• Assignee: Unassigned
• Reporter: Jingsong Lee
• Created: 16/Sep/19 06:07
• Updated: 18/Apr/22 22:38

Description

There are still many limitations to planner's type support.

Sub-Tasks

• The type of a union of CHAR columns of different lengths should be VARCHAR: Closed
• Incorrect CHAR type support in Flink SQL and Table API: Open
• Introduce SqlTimestamp as internal representation for high precision of timestamp: Closed
• Support precision of TimeType: In Progress
• Support precision of DayTimeIntervalType and YearMonthIntervalType: Open
• Support StructuredType: Open
• Support ZonedTimestampType: Open
• Cast exception is thrown when count distinct on decimal fields: Resolved
• Support precision of TimestampType in blink planner: Closed
• Support precision of TimestampType in built-in SQL functions and operators: Closed
• Introduce setTimestamp/getTimestamp interface to TypeGetterSetters/VectorizedColumnBatch and writeTimestamp interface to BinaryWriter: Closed
• Support precision of LocalZonedTimestampType in blink planner: Closed
• Support timestamp type in hive: Closed