[
https://issues.apache.org/jira/browse/CALCITE-5701?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Guillaume Massé updated CALCITE-5701:
-------------------------------------
Description:
[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}
was:
[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}
> Add NAMED_STRUCT function (enabled in Spark library)
> ----------------------------------------------------
>
> 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)
