[
https://issues.apache.org/jira/browse/SPARK-43220?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jia Fan resolved SPARK-43220.
-----------------------------
Resolution: Invalid
> INSERT INTO REPLACE statement can't support WHERE with bool_expression
> ----------------------------------------------------------------------
>
> Key: SPARK-43220
> URL: https://issues.apache.org/jira/browse/SPARK-43220
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.4.0
> Reporter: Jia Fan
> Priority: Major
> Attachments: image-2023-04-20-23-40-25-212.png
>
>
> {code:java}
> sql("CREATE TABLE persons (name string,address String,ssn int) USING parquet")
> sql("CREATE TABLE persons2 (name string,address String,ssn int) USING
> parquet")
> sql("INSERT INTO TABLE persons VALUES " +
> "('Dora Williams', '134 Forest Ave, Menlo Park', 123456789)," +
> "('Eddie Davis','245 Market St, Milpitas',345678901)")
> sql("INSERT INTO TABLE persons2 VALUES ('Ashua Hill', '456 Erica Ct,
> Cupertino', 432795921)")
> sql("INSERT INTO persons REPLACE WHERE ssn = 123456789 SELECT * FROM
> persons2")
> sql("SELECT * FROM persons").show(){code}
> When use `INSERT INTO table REPLACE WHERE`, only support `WHERE TRUE` at now.
> `WHERE ssn = 123456789` or `WHERE FALSE` both not support.
> !image-2023-04-20-23-40-25-212.png|width=795,height=152!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
