[
https://issues.apache.org/jira/browse/SPARK-29715?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17004649#comment-17004649
]
Takeshi Yamamuro commented on SPARK-29715:
------------------------------------------
I'll close this because this is pg-specific and useless for Spark.
> Support SELECT statements in VALUES of INSERT INTO
> --------------------------------------------------
>
> Key: SPARK-29715
> URL: https://issues.apache.org/jira/browse/SPARK-29715
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: Takeshi Yamamuro
> Priority: Major
>
> In PgSQL, we can use SELECT statements in VALUES of INSERT INTO;
> {code}
> postgres=# create table t (c0 int, c1 int);
> CREATE TABLE
> postgres=# insert into t values (3, (select 1));
> INSERT 0 1
> postgres=# select * from t;
> c0 | c1
> ----+----
> 3 | 1
> (1 row)
> {code}
> {code}
> scala> sql("""create table t (c0 int, c1 int) using parquet""")
> scala> sql("""insert into t values (3, (select 1))""")
> org.apache.spark.sql.AnalysisException: unresolved operator 'Project
> [unresolvedalias(1, None)];;
> 'InsertIntoStatement 'UnresolvedRelation [t], false, false
> +- 'UnresolvedInlineTable [col1, col2], [List(3, scalar-subquery#0 [])]
> +- 'Project [unresolvedalias(1, None)]
> +- OneRowRelation
> at
> org.apache.spark.sql.catalyst.analysis.CheckAnalysis.failAnalysis(CheckAnalysis.scala:47)
> at
> org.apache.spark.sql.catalyst.analysis.CheckAnalysis.failAnalysis$(CheckAnalysis.scala:46)
> at
> org.apache.spark.sql.catalyst.analysis.Analyzer.failAnalysis(Analyzer.scala:122)
> at
> org.apache.spark.sql.catalyst.analysis.CheckAnalysis.$anonfun$checkAnalysis$36(CheckAnalysis.scala:540)
> at
> org.apache.spark.sql.catalyst.analysis.CheckAnalysis.$anonfun$checkAnalysis$36$adapted(CheckAnalysis.scala:538)
> at
> org.apache.spark.sql.catalyst.trees.TreeNode.foreachUp(TreeNode.scala:154)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
