Jia Fan created SPARK-43220: ------------------------------- Summary: 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
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() When use `INSERT INTO table REPLACE WHERE`, only support `WHERE TRUE` at now. `WHERE ssn = 123456789` or `WHERE FALSE` both not support. -- 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