You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2024/08/05 16:27:00 UTC

[jira] [Updated] (SPARK-48824) Add SQL syntax in create/replace table to create an identity column

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

ASF GitHub Bot updated SPARK-48824:
-----------------------------------
    Labels: pull-request-available  (was: )

> Add SQL syntax in create/replace table to create an identity column
> -------------------------------------------------------------------
>
>                 Key: SPARK-48824
>                 URL: https://issues.apache.org/jira/browse/SPARK-48824
>             Project: Spark
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions: 4.0.0
>            Reporter: Carmen Kwan
>            Priority: Major
>              Labels: pull-request-available
>
> Add SQL support for creating identity columns. Identity Column syntax should be flexible such that users can specify 
>  * whether identity values are always generated by the system
>  * (optionally) the starting value of the column 
>  * (optionally) the increment/step of the column
> The SQL syntax support should also allow flexible ordering of the increment and starting values, as both variants are used in the wild by other systems (e.g. [PostgreSQL|https://www.postgresql.org/docs/current/sql-createsequence.html] [Oracle).|https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/CREATE-SEQUENCE.html#GUID-E9C78A8C-615A-4757-B2A8-5E6EFB130571] That is, we should allow both
> {code:java}
> START WITH <start> INCREMENT BY <step>{code}
> and 
> {code:java}
> INCREMENT BY <step> START WITH <start>{code}
> .
> For example, we should be able to define
> {code:java}
> CREATE TABLE default.example (
>   id LONG GENERATED ALWAYS AS IDENTITY,
>   id2 LONG GENERATED BY DEFAULT START WITH 0 INCREMENT BY -10,
>   id3 LONG GENERATED ALWAYS AS IDENTITY INCREMENT BY 2 START WITH -8,
>   value LONG
> )
> {code}
> This will enable defining identity columns in Spark SQL for data sources that support it. 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org