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)

Reply via email to