[SPARK-23210] Introduce the concept of default value to schema

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Incomplete
• Affects Version/s: 2.2.1
• Component/s: SQL
• Labels: bulk-closed
• Target Version/s: 3.0.0
• Assignee: Unassigned
• Reporter: LvDongrong
• Created: 25/Jan/18 03:31
• Updated: 08/Oct/19 05:42
• Resolved: 08/Oct/19 05:42

Description

There is no concept of DEFAULT VALUE for schema in spark now.
Our team want to support insert into serial columns of table,like "insert into (a, c) values ("value1", "value2") for our use case, but the default vaule of column is not definited. In hive, the default vaule of column is NULL if we don't specify.
So I think maybe it is necessary to introduce the concept of default value to schema in spark.