[BEAM-5120] Support Complex type in BeamSQL

• Type: Task
• Status: Open
• Priority: P3
• Resolution: Unresolved
• Component/s: dsl-sql
• Assignee: Unassigned
• Reporter: Rui Wang
• Created: 09/Aug/18 20:38
• Updated: 03/Jun/22 21:58

Description

We want have a smooth experience of complex type in BeamSQL.

 

For example, BeamSQL could support nested row in arbitrary levels (Row<Row<Row<...>>>) in both read and write from/to arbitrary sources. 

Issue Links

• contains: BEAM-4196 [SQL] Support Complex Types in DDL

Sub-Tasks

• Read complex types of data by SQL: Resolved
• [SQL] Support Complex Types in DDL: Resolved
• Investigate flattening issue of nested Row: Resolved
• select Inner row of nested row does not work: Open
• Fix the failing complex type test due to misusing reversed keyword of Calcite: Resolved
• Investigate if we can disable Row type flattening in Calcite: Resolved
• Test nested select query with nested Row: Open
• Investigate if nested row constructor works: Resolved
• Investigate if we can insert into a table with Row type: Resolved
• Disable Row flattening in Apache Calcite: Resolved