[ https://issues.apache.org/jira/browse/CALCITE-6027?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ran Tao updated CALCITE-6027: ----------------------------- Summary: Add the rule to rewrite cardinality on map_keys and map_values functions (was: Add the rule to simplify cardinality on map_keys and map_values functions) > Add the rule to rewrite cardinality on map_keys and map_values functions > ------------------------------------------------------------------------ > > Key: CALCITE-6027 > URL: https://issues.apache.org/jira/browse/CALCITE-6027 > Project: Calcite > Issue Type: New Feature > Components: core > Affects Versions: 1.35.0 > Reporter: Ran Tao > Priority: Major > > when we call cardinality on map_keys or map_values, such as: > {code:java} > select cardinality(map_keys(map['foo', 1, 'bar', 2])); > select cardinality(map_values(map['foo', 1, 'bar', 2]));{code} > they can be safely simplified to > {code:java} > select cardinality(map['foo', 1, 'bar', 2]); > select cardinality(map['foo', 1, 'bar', 2]); {code} > > Some other mature engines such as presto/trino has same optimized logic. -- This message was sent by Atlassian Jira (v8.20.10#820010)