[jira] [Created] (SPARK-45895) Combine multiple like to like all

[Yuming Wang (Jira)]

Yuming Wang created SPARK-45895:
-----------------------------------

             Summary: Combine multiple like to like all
                 Key: SPARK-45895
                 URL: https://issues.apache.org/jira/browse/SPARK-45895
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 4.0.0
            Reporter: Yuming Wang



{code:scala}
   spark.sql("create table t(a string, b string, c string) using parquet")
    spark.sql(
      """
        |select * from t where
        |substr(a, 1, 5) like '%a%' and
        |substr(a, 1, 5) like '%b%'
        |""".stripMargin).explain(true)
{code}

We can optimize the query to:
{code:scala}
    spark.sql(
      """
        |select * from t where
        |substr(a, 1, 5) like all('%a%', '%b%')
        |""".stripMargin).explain(true)
{code}





--
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