You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Alessandro Solimando (Jira)" <ji...@apache.org> on 2021/12/03 10:20:00 UTC

[jira] [Updated] (CALCITE-4918) Add a VARIANT data type

     [ https://issues.apache.org/jira/browse/CALCITE-4918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alessandro Solimando updated CALCITE-4918:
------------------------------------------
    Issue Type: Improvement  (was: Bug)

> Add a VARIANT data type
> -----------------------
>
>                 Key: CALCITE-4918
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4918
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Julian Hyde
>            Priority: Major
>
> Add a VARIANT data type. It would be a tagged union, and allow values of multiple types to be stored, along with a type indicator so that the actual type of each value can be discerned.
> VARIANT is not in the SQL standard. I know of three databases that have a VARIANT type: MSSQL, Snowflake, Teradata. Calcite's VARIANT type will probably draw from all three; however, the goal is not full compliance with any of them, but useful functionality.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)