[BEAM-9536] Return type of window start/end functions is incorrectly inferred to be INT64

• Type: Improvement
• Status: Resolved
• Priority: P2
• Resolution: Fixed
• Fix Version/s: 2.21.0
• Component/s: dsl-sql-zetasql
• Assignee: Robin Qiu
• Reporter: Robin Qiu
• Created: 18/Mar/20 01:30
• Updated: 16/May/20 14:14
• Resolved: 24/Mar/20 17:45

Description

Our current implementation does not have the correct return type information of the window start/end functions (e.g. TUMBLE_START).

LOC that cause the problem: https://github.com/apache/beam/blob/646f596988be9d6a739090f48d2fed07c8dfc17c/sdks/java/extensions/sql/zetasql/src/main/java/org/apache/beam/sdk/extensions/sql/zetasql/SqlAnalyzer.java#L62

We should specify the return type explicitly here in the CREATE statements.

Issue Links

• links to: GitHub Pull Request #11152