[CALCITE-1554] Supporting NULL as column in SELECT Statement

• Type: Wish
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Julian Stenzel
• Created: 23/Dec/16 15:47
• Updated: 22/Feb/19 01:22

Description

it would be cool to support null as an possible column in the SELECT statement.

Use Case:

UNION two tables x,y with a 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

Issue Links

• is related to: CALCITE-815 Add an option to allow empty strings to represent null values