morvenhuang created SPARK-38914:
-----------------------------------
Summary: Allow user to insert specified columns into insertable
view
Key: SPARK-38914
URL: https://issues.apache.org/jira/browse/SPARK-38914
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 3.2.1
Reporter: morvenhuang
The option `spark.sql.defaultColumn.useNullsForMissingDefautValues` allows us
to insert specified columns into table
([SPARK-38795|https://issues.apache.org/jira/browse/SPARK-38795]), but
currently this option does not work for insertable view,
Below INSERT INTO will result in AnalysisException even when the
useNullsForMissingDefautValues option is true,
{code:java}
spark.sql("CREATE TEMPORARY VIEW v1 (c1 int, c2 string) USING
org.apache.spark.sql.json.DefaultSource OPTIONS ( path 'json_dir')");
spark.sql("INSERT INTO v1(c1) VALUES(100)");
org.apache.spark.sql.AnalysisException: unknown requires that the data to be
inserted have the same number of columns as the target table: target table has
2 column(s) but the inserted data has 1 column(s), including 0 partition
column(s) having constant value(s).
{code}
I can provide a fix for this issue.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
