[ https://issues.apache.org/jira/browse/SPARK-38914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-38914: ------------------------------------ Assignee: (was: Apache Spark) > 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 > Priority: Minor > > The option `spark.sql.defaultColumn.useNullsForMissingDefautValues` allows us > to insert specified columns into table (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