[jira] [Comment Edited] (SPARK-38334) Implement support for DEFAULT values for columns in tables

["Daniel (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-38334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17580028#comment-17580028 ] 

Daniel edited comment on SPARK-38334 at 8/16/22 3:48 AM:
---------------------------------------------------------

I think it is OK to declare that this feature is implemented in Apache Spark now. Marking this as fixed. We can always reopen (or file another ticket) if we would like to support other data sources.


was (Author: JIRAUSER285772):
I think it is OK to declare that this feature is implemented in Apache Spark now. Marking this as fixed.

> Implement support for DEFAULT values for columns in tables 
> -----------------------------------------------------------
>
>                 Key: SPARK-38334
>                 URL: https://issues.apache.org/jira/browse/SPARK-38334
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.4.0
>            Reporter: Daniel
>            Priority: Major
>             Fix For: 3.4.0
>
>
> This story tracks the implementation of DEFAULT values for columns in tables.
> CREATE TABLE and ALTER TABLE invocations will support setting column default values for future operations. Following INSERT, UPDATE, MERGE statements may then reference the value using the DEFAULT keyword as needed.
> Examples:
> {code:sql}
> CREATE TABLE T(a INT, b INT NOT NULL);
> -- The default default is NULL
> INSERT INTO T VALUES (DEFAULT, 0);
> INSERT INTO T(b)  VALUES (1);
> SELECT * FROM T;
> (NULL, 0)
> (NULL, 1)
> -- Adding a default to a table with rows, sets the values for the
> -- existing rows (exist default) and new rows (current default).
> ALTER TABLE T ADD COLUMN c INT DEFAULT 5;
> INSERT INTO T VALUES (1, 2, DEFAULT);
> SELECT * FROM T;
> (NULL, 0, 5)
> (NULL, 1, 5)
> (1, 2, 5) {code}



--
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