JingsongLi opened a new pull request, #5754:
URL: https://github.com/apache/paimon/pull/5754
<!-- Please specify the module before the PR name: [core] ... or [flink] ...
-->
### Purpose
Paimon allows specifying default values for columns. When users write to
these tables without explicitly providing
values for certain columns, Paimon automatically generates default values
for these columns.
#### Create Table
You can create a table with columns with default values using the following
SQL:
```sql
CREATE TABLE my_table (
a BIGINT,
b STRING DEFAULT 'my_value',
c INT DEFAULT 5
);
```
#### Insert Table
For SQL commands that execute table writes, such as the `INSERT`, `UPDATE`,
and `MERGE` commands, the `DEFAULT` keyword
or `NULL` value is parsed into the default value specified for the
corresponding column.
#### Limitation
Currently, only specifying default values when creating tables is supported,
and the following usage is not supported:
1. Not support alter table add column with default value, for example:
`ALTER TABLE T ADD COLUMN d INT DEFAULT 5;`.
2. Not support alter table alter column set default value, for example:
`ALTER TABLE T ALTER COLUMN d SET DEFAULT 5;`.
### Tests
<!-- List UT and IT cases to verify this change -->
### API and Format
<!-- Does this change affect API or storage format -->
### Documentation
<!-- Does this change introduce a new feature -->
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscr...@paimon.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
