[
https://issues.apache.org/jira/browse/CALCITE-1554?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Stenzel updated CALCITE-1554:
------------------------------------
Description:
it would be cool to support null as an column in the SELECT statement.
Use Case:
UNION two tables x,y with a different number of columns e.g.
{code}
Select id, name, age from x
Union
Select id, name, Null as age from y
{code}
this should be a useful use case for adressing NoSQL databases where our data
exist in different schemes
was:
it would be cool to support null as an column in the SELECT statement.
Use Case:
UNION two tables x,y with different number of columns e.g.
Select id, name, age from x
Union
Select id, name, Null as age from y
this should be a useful use case for adressing NoSQL databases where our data
exist in different schemes
> Supporting NULL as column in SELECT Statement
> ---------------------------------------------
>
> Key: CALCITE-1554
> URL: https://issues.apache.org/jira/browse/CALCITE-1554
> Project: Calcite
> Issue Type: Wish
> Reporter: Julian Stenzel
> Assignee: Julian Hyde
>
> it would be cool to support null as an column in the SELECT statement.
> Use Case:
> UNION two tables x,y with a different number of columns e.g.
> {code}
> Select id, name, age from x
> Union
> Select id, name, Null as age from y
> {code}
> this should be a useful use case for adressing NoSQL databases where our data
> exist in different schemes
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
