[CALCITE-4554] TIMESTAMP WITH LOCAL TIME ZONE type is not supported in Snapshot and MatchRecognize validation

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.35.0
• Labels: pull-request-available
• Assignee: Sergey Nuyanzin
• Reporter: Leonard Xu
• Created: 27/Mar/21 07:42
• Updated: 27/Jul/23 10:22
• Resolved: 11/May/23 20:31

Description

When I plan to support TIMESTAMP WITH LOCAL TIME ZONE type in Flink project , I found only TIMESTAMP is supported in system period type of Snapshot node and first orderBy column type of MatchRecognize node in Calcite. So I have to override the class org.apache.calcite.sql.validate.SqlValidatorImpl to skip the validate logic.

Both TIMESTAMP and TIMESTAMP WITH LOCAL TIME ZONE belong to SqlTypeFamily.TIMESTAMP, Could we also support TIMESTAMP WITH LOCAL TIME ZONE in these situations?

Issue Links

• links to: GitHub Pull Request #3106