Thoughts on how to improve string search queries
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-01-2023 01:47 PM
Please see sample code I am running below. What options can I explore to improve speed of query execution in such a scenario? Current full code takes about 4 hrs to run on 1.5 billion rows. Thanks!
SELECT
fullVisitorId
,VisitId
,EventDate
,PagePath
,deviceCategory
FROM ga360.ga_sessions a
WHERE
(
contains(lower(PagePath) , 'step-one')
OR contains(lower(PagePath) , 'step-two')
OR contains(lower(PagePath) , 'step-three')
)
AND not contains(utm_source,'ads')
AND hitstype = 'PAGE'
and a.EventDateKey >= 20200101
0 REPLIES 0

