[ https://issues.apache.org/jira/browse/SPARK-43220?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714794#comment-17714794 ]
Jia Fan commented on SPARK-43220: --------------------------------- After I tested with another way, it works. My fault. > 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