You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@impala.apache.org by "gaoxiaoqing (Jira)" <ji...@apache.org> on 2021/10/13 04:40:00 UTC

[jira] [Created] (IMPALA-10968) optimize regular expression matching

gaoxiaoqing created IMPALA-10968:
------------------------------------

             Summary: optimize regular expression matching
                 Key: IMPALA-10968
                 URL: https://issues.apache.org/jira/browse/IMPALA-10968
             Project: IMPALA
          Issue Type: Improvement
            Reporter: gaoxiaoqing
            Assignee: gaoxiaoqing


eg:
{code:java}
select 
  case when p__latest_referrer rlike '.*ssid=0.*' 
  and city = '北京' then 1 when p__latest_referrer rlike '.*ssid=0.*' 
  and city = '上海' then 2 end as x 
from 
  event_ros_p7 
where 
  p__latest_referrer;
{code}
the above sql need match pattern '.*ssid=0.*' two times on each line，if we store the match result on each line, it only need match one time on each line. 

 

key: property p__latest_referrer and pattern ".*ssid"

value: true or false

 

 

 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)