Yueyang Qiu created BEAM-9191:
---------------------------------
Summary: CAST does not work in some cases due to bugs in Calcite
unparsing
Key: BEAM-9191
URL: https://issues.apache.org/jira/browse/BEAM-9191
Project: Beam
Issue Type: Improvement
Components: dsl-sql-zetasql
Reporter: Yueyang Qiu
Assignee: Yueyang Qiu
For example:
"CAST(xxx AS TIMESTAMP)" is unparsed to "CAST(xxx AS TIMESTAMP(0))"
The fix is already in the newest version of BigQuerySqlDialect.java in Calcite
(using
[SqlAlienSystemTypeNameSpec|https://github.com/apache/calcite/blob/3621b61ea0bca953652a2e6d1838e5a296c6a007/core/src/main/java/org/apache/calcite/sql/dialect/BigQuerySqlDialect.java#L293]),
so this issue will be fixed after we update our vendored Calcite version.
I tried to patch the change to BeamBigQuerySqlDialect.java (similar to what we
did for other features) but this change is very large (multiple new classes) to
patch.
[~apilloud]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
