[
https://issues.apache.org/jira/browse/FLINK-18726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17271323#comment-17271323
]
Jark Wu commented on FLINK-18726:
---------------------------------
Thanks [~docete], I also found this is not an easy work which involves computed
columns, partitions keys, Calcite. Considering we should aim this issue into
1.13 release and the original assignee didn't respond for a long time. I will
assign this issue to you. Looking forward to your pull request.
> Support INSERT INTO specific columns
> ------------------------------------
>
> Key: FLINK-18726
> URL: https://issues.apache.org/jira/browse/FLINK-18726
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Reporter: Caizhi Weng
> Assignee: Atri Sharma
> Priority: Major
> Labels: sprint
> Fix For: 1.13.0
>
>
> Currently Flink only supports insert into a table without specifying columns,
> but most database systems support insert into specific columns by
> {code:sql}
> INSERT INTO table_name(column1, column2, ...) ...
> {code}
> The columns not specified will be filled with default values or {{NULL}} if
> no default value is given when creating the table.
> As Flink currently does not support default values when creating tables, we
> can fill the unspecified columns with {{NULL}} and throw exceptions if there
> are columns with {{NOT NULL}} constraints.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
