'REGEXP_SUBSTR equivalent in HIVE SQ
I'm looking for the equivalent of REGEXP_SUBSTR in HIVE
CASE WHEN REGEXP_INSTR(campaign,'(Retention|RTN)') <> 0 THEN 'Retention'
WHEN REGEXP_INSTR(campaign,'(Conquest|CQT)') <> 0 THEN 'Conquest'
WHEN REGEXP_INSTR(campaign,'(Segment|SGT)') <> 0 THEN 'Segment'
ELSE 'Missing Tactic' END AS Strategy,
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|