[BEAM-9191] CAST does not work in some cases due to bugs in Calcite unparsing

• Type: Improvement
• Status: Open
• Priority: P3
• Resolution: Unresolved
• Component/s: dsl-sql-zetasql
• Labels: beam-fixit
• Assignee: Unassigned
• Reporter: Robin Qiu
• Created: 24/Jan/20 21:23
• Updated: 04/Jun/22 15:27

Description

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), 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.

cc: apilloud

Issue Links

• blocks: BEAM-10238 [Umbrella] Improve Beam ZetaSQL type system
• is blocked by: BEAM-9379 Upgrade to Calcite 1.26.0
• links to: GitHub Pull Request #11953