[GitHub] [spark] lyy-pineapple commented on pull request #38171: [SPARK-9213] [SQL] Improve regular expression performance (via joni)

[GitBox <gi...@apache.org>]

lyy-pineapple commented on PR #38171:
URL: https://github.com/apache/spark/pull/38171#issuecomment-1365029419

   > <img alt="image" width="838" src="https://user-images.githubusercontent.com/8748814/204439049-53f0bd4f-9ea0-4289-8268-d16aef5b4334.png">
   > 
   > @lyy-pineapple Would you share the test sql pattern? I test some cases and haven't seen such improvement
   
   test a simple sql 
   >  select id,
       case when t1 rlike '.*abc.*cde.*' then 1 
       when t1 rlike '.*bbd*cde.*' then 2 
       when t1 rlike '.*cbe*cde.*' then 3
        when   t1 rlike '.*dbf*cde.*'  then 4
       when t1 rlike  '.*ebg*cde.*' then 5 
       else 0
       end  as t1
       from xxx
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org