Dongjoon Hyun created SPARK-14545:
-------------------------------------

             Summary: Improve `LikeSimplification` by adding `a%b` rule
                 Key: SPARK-14545
                 URL: https://issues.apache.org/jira/browse/SPARK-14545
             Project: Spark
          Issue Type: New Feature
          Components: Optimizer
            Reporter: Dongjoon Hyun


Current `LikeSimplification` handles the following four rules.
- 'a%' => expr.StartsWith("a")
- '%b' => expr.EndsWith("b")
- '%a%' => expr.Contains("a")
- 'a' => EqualTo("a")

This issue adds the following rule.
- 'a%b' => expr.Length() > 2 && expr.StartsWith("a") && expr.EndsWith("b")
Here, 2 is statically calculated from "a".size + "b".size.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to