[BEAM-10238] [Umbrella] Improve Beam ZetaSQL type system

• Type: New Feature
• Status: Open
• Priority: P3
• Resolution: Unresolved
• Component/s: dsl-sql-zetasql
• Assignee: Unassigned
• Reporter: Robin Qiu
• Created: 11/Jun/20 06:20
• Updated: 04/Jun/22 17:09

Description

This is an umbrella issue for several improvements we plan to make to the Beam ZetaSQL type system.

Issue Links

• is a parent of: BEAM-10607 Support micro-second ZetaSQL TIMESTAMP in BeamSQL
• is a parent of: BEAM-9178 Support ZetaSQL TIMESTAMP functions in BeamSQL
• is a parent of: BEAM-9641 Support ZetaSQL DATE functions in BeamSQL
• is a parent of: BEAM-10219 Support ZetaSQL TIME functions in BeamSQL
• is a parent of: BEAM-10239 Support ZetaSQL NUMERIC type in BeamSQL
• is a parent of: BEAM-10240 Support ZetaSQL DATETIME functions in BeamSQL
• is a parent of: BEAM-10438 Turn on functions supported by BeamZetaSqlCalcRel
• is a parent of: BEAM-10490 Support read/write ZetaSQL DATE/TIME types from/to BigQuery
• is a parent of: BEAM-9179 Refactor Beam ZetaSQL type translation code
• is blocked by: BEAM-10651 Beam ZetaSQL does not handle NULL arrays properly
• is blocked by: BEAM-10783 ZetaSQL failed on WITH queries because wrong ref column index calculated in JoinScanWithRefConverter
• is blocked by: BEAM-10459 Support ZetaSQL aggregate functions for NUMERIC type
• is blocked by: BEAM-10606 Support ZetaSQL DataTimePart "week with weekday" in EXTRACT and TRUNC
• is blocked by: BEAM-9191 CAST does not work in some cases due to bugs in Calcite unparsing
• is blocked by: BEAM-10340 Lost of precision when casting ZetaSQL time with microsecond-precision
• is blocked by: BEAM-9182 Support NULL parameter in BeamZetaSqlCalcRel
• is blocked by: BEAM-8057 Support NAN, INF, and -INF
• is blocked by: BEAM-10611 Use ZetaSQL Value.createDatetimeValue(LocalDateTime) function to avoid extra conversions