You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Leonard Xu (Jira)" <ji...@apache.org> on 2021/03/27 07:47:00 UTC
[jira] [Updated] (CALCITE-4554) TIMESTAMP WITH LOCAL TIME ZONE type
is not supported in Snapshot and MatchRecognize validation
[ https://issues.apache.org/jira/browse/CALCITE-4554?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Leonard Xu updated CALCITE-4554:
--------------------------------
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?
was:
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 situation?
> TIMESTAMP WITH LOCAL TIME ZONE type is not supported in Snapshot and MatchRecognize validation
> -----------------------------------------------------------------------------------------------
>
> Key: CALCITE-4554
> URL: https://issues.apache.org/jira/browse/CALCITE-4554
> Project: Calcite
> Issue Type: Improvement
> Reporter: Leonard Xu
> Priority: Major
>
> 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?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)