[ https://issues.apache.org/jira/browse/CALCITE-5701?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Guillaume Massé updated CALCITE-5701: ------------------------------------- Labels: (was: Spark) > Implement Apache Spark named_struct > ----------------------------------- > > Key: CALCITE-5701 > URL: https://issues.apache.org/jira/browse/CALCITE-5701 > Project: Calcite > Issue Type: New Feature > Components: core > Reporter: Guillaume Massé > Priority: Minor > > [https://spark.apache.org/docs/3.4.0/api/sql/index.html#named_struct] > > {code:java} > spark.sql("""select named_struct("a", 1, "b", 2)""") > res4: org.apache.spark.sql.DataFrame = [named_struct(a, 1, b, 2): struct<a: > int, b: int>] > Calcite: > SELECT named_struct("a", 1, "b", 2); > type: row(a int not null, b int not null){code} > > It's also possible to be nested: > {code:java} > spark.sql("""select named_struct("a", 1, "b", named_struct("c", 2))""") > res5: org.apache.spark.sql.DataFrame = [named_struct(a, 1, b, named_struct(c, > 2)): struct<a: int, b: struct<c: int>>] {code} > {code:java} > Calcite: > SELECT named_struct("a", 1, "b", named_struct("c", 2)); > type: row(a int not null, b row(c int not null) not null){code} -- This message was sent by Atlassian Jira (v8.20.10#820010)