You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Steven Talbot (Jira)" <ji...@apache.org> on 2022/10/12 18:02:00 UTC
[jira] [Updated] (CALCITE-5330) TIMESTAMPDIFF call cannot work with RelJson
[ https://issues.apache.org/jira/browse/CALCITE-5330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Talbot updated CALCITE-5330:
-----------------------------------
Description:
The TIMESTAMPDIFF function parses out with TimeUnit, rather than TimeUnitRange. Due to [https://github.com/apache/calcite/blob/2c30a56158cdd351d35725006bc1f76bb6aac75b/core/src/main/java/org/apache/calcite/sql/fun/SqlTimestampDiffFunction.java#L62,] you can't even workaround by subbing in TimeUnitRange after parse.
TimeUnit is incompatible with JSON serialization in RelJson, which uses RelEnumTypes to serialize enum values, and that only has TimeUnitRange [https://github.com/apache/calcite/blob/2c30a56158cdd351d35725006bc1f76bb6aac75b/core/src/main/java/org/apache/calcite/rel/externalize/RelEnumTypes.java#L79]
So attempting to serialize you get
{noformat}
cannot serialize enum value to JSON: org.apache.calcite.avatica.util.TimeUnit.MINUTE
java.lang.AssertionError: cannot serialize enum value to JSON: org.apache.calcite.avatica.util.TimeUnit.MINUTE
at org.apache.calcite.rel.externalize.RelEnumTypes.fromEnum(RelEnumTypes.java:102)
at org.apache.calcite.rel.externalize.RelEnumTypes.fromEnum(RelEnumTypes.java:94)
at org.apache.calcite.rel.externalize.RelJson.toJson(RelJson.java:491)
at org.apache.calcite.rel.externalize.RelJson.toJson(RelJson.java:517)
at org.apache.calcite.rel.externalize.RelJson.toJson(RelJson.java:390)
at org.apache.calcite.rel.externalize.RelJson.toJson(RelJson.java:402)
at org.apache.calcite.rel.externalize.RelJsonWriter.put(RelJsonWriter.java:90)
at org.apache.calcite.rel.externalize.RelJsonWriter.explain_(RelJsonWriter.java:73){noformat}
was:
The TIMESTAMPDIFF function parses out with TimeUnit, rather than TimeUnitRange. Due to [https://github.com/apache/calcite/blob/2c30a56158cdd351d35725006bc1f76bb6aac75b/core/src/main/java/org/apache/calcite/sql/fun/SqlTimestampDiffFunction.java#L62,] you can't even workaround by subbing in TimeUnitRange after parse.
TimeUnit is incompatible with JSON serialization in RelJson, which uses RelEnumTypes to serialize enum values, and that only has TimeUnitRange [https://github.com/apache/calcite/blob/2c30a56158cdd351d35725006bc1f76bb6aac75b/core/src/main/java/org/apache/calcite/rel/externalize/RelEnumTypes.java#L79]
So attempting to serialize you get
{noformat}
cannot serialize enum value to JSON: org.apache.calcite.avatica.util.TimeUnit.MINUTE
java.lang.AssertionError: cannot serialize enum value to JSON: org.apache.calcite.avatica.util.TimeUnit.MINUTE
at org.apache.calcite.rel.externalize.RelEnumTypes.fromEnum(RelEnumTypes.java:102)
at org.apache.calcite.rel.externalize.RelEnumTypes.fromEnum(RelEnumTypes.java:94)
at org.apache.calcite.rel.externalize.RelJson.toJson(RelJson.java:491)
at org.apache.calcite.rel.externalize.RelJson.toJson(RelJson.java:517)
at org.apache.calcite.rel.externalize.RelJson.toJson(RelJson.java:390)
at org.apache.calcite.rel.externalize.RelJson.toJson(RelJson.java:402)
at org.apache.calcite.rel.externalize.RelJsonWriter.put(RelJsonWriter.java:90)
at org.apache.calcite.rel.externalize.RelJsonWriter.explain_(RelJsonWriter.java:73){noformat}
> TIMESTAMPDIFF call cannot work with RelJson
> -------------------------------------------
>
> Key: CALCITE-5330
> URL: https://issues.apache.org/jira/browse/CALCITE-5330
> Project: Calcite
> Issue Type: Bug
> Reporter: Steven Talbot
> Priority: Major
>
> The TIMESTAMPDIFF function parses out with TimeUnit, rather than TimeUnitRange. Due to [https://github.com/apache/calcite/blob/2c30a56158cdd351d35725006bc1f76bb6aac75b/core/src/main/java/org/apache/calcite/sql/fun/SqlTimestampDiffFunction.java#L62,] you can't even workaround by subbing in TimeUnitRange after parse.
> TimeUnit is incompatible with JSON serialization in RelJson, which uses RelEnumTypes to serialize enum values, and that only has TimeUnitRange [https://github.com/apache/calcite/blob/2c30a56158cdd351d35725006bc1f76bb6aac75b/core/src/main/java/org/apache/calcite/rel/externalize/RelEnumTypes.java#L79]
> So attempting to serialize you get
> {noformat}
> cannot serialize enum value to JSON: org.apache.calcite.avatica.util.TimeUnit.MINUTE
> java.lang.AssertionError: cannot serialize enum value to JSON: org.apache.calcite.avatica.util.TimeUnit.MINUTE
> at org.apache.calcite.rel.externalize.RelEnumTypes.fromEnum(RelEnumTypes.java:102)
> at org.apache.calcite.rel.externalize.RelEnumTypes.fromEnum(RelEnumTypes.java:94)
> at org.apache.calcite.rel.externalize.RelJson.toJson(RelJson.java:491)
> at org.apache.calcite.rel.externalize.RelJson.toJson(RelJson.java:517)
> at org.apache.calcite.rel.externalize.RelJson.toJson(RelJson.java:390)
> at org.apache.calcite.rel.externalize.RelJson.toJson(RelJson.java:402)
> at org.apache.calcite.rel.externalize.RelJsonWriter.put(RelJsonWriter.java:90)
> at org.apache.calcite.rel.externalize.RelJsonWriter.explain_(RelJsonWriter.java:73){noformat}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)