Daniel created SPARK-38334:
------------------------------
Summary: 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: Story
Components: SQL
Affects Versions: 3.2.1
Reporter: Daniel
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.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
