You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Zhen Chen (Jira)" <ji...@apache.org> on 2025/04/04 13:56:00 UTC
[jira] [Created] (CALCITE-6938) Support zero value creation of nested data types
Zhen Chen created CALCITE-6938:
----------------------------------
Summary: Support zero value creation of nested data types
Key: CALCITE-6938
URL: https://issues.apache.org/jira/browse/CALCITE-6938
Project: Calcite
Issue Type: Improvement
Reporter: Zhen Chen
Assignee: Zhen Chen
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[0]
# MULTISET: Zero value represented as an zero multiset. e.g. MULTISET<INTEGER> → MULTISET[0]
# 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>>>}}
* ......
--
This message was sent by Atlassian Jira
(v8.20.10#820010)