[jira] [Created] (SPARK-43220) INSERT INTO REPLACE statement can't support WHERE with bool_expression

["Jia Fan (Jira)" <ji...@apache.org>]

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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org