Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
This implementation ensures zero values of various nested data types can be used in COALESCE(nestedCol, nestedZero) expressions.
Basic Nested Types:
- ARRAY: Zero value represented as an zero array. e.g. ARRAY<INTEGER> → ARRAY[]
- MULTISET: Zero value represented as an zero multiset. e.g. MULTISET<INTEGER> → MULTISET[]
- MAP: Zero value represented as an zero map. e.g. MAP<INTEGER, INTEGER> → MAP(0, 0)
- ROW: Zero value with all fields initialized to their respective type's zero value. e.g. ROW<INTEGER, INTEGER> → ROW(0, 0)
Complex Nested Types:
- ARRAY<ARRAY<INTEGER>>
- ARRAY<MAP<VARCHAR(50), INTEGER>>
- MAP<STRING, ARRAY<ROW<INT, BOOLEAN>>>
- ......
Attachments
Issue Links
- links to