Hi,

ANSI SQL doesn't define regex operator.
Drill neither.

Doesn't it enough 'LIKE' operator?
Or, REGEXP_REPLACE/SUBSTR functions may help you.
https://drill.apache.org/docs/string-manipulation/

-- 
Miura, Masahide

-----Original Message-----
From: Nicolas Paris [mailto:nipari...@gmail.com] 
Sent: Tuesday, February 02, 2016 9:04 PM
To: user@drill.apache.org
Subject: REGEX search Operator

Hello,

I can't find any reference in the documentation about a regex operator.

I would like to be able to query this way :

SELECT *
FROM xxx
WHERE  text_field   regexOperator    'regex_pattern';

Thanks for helping,

Reply via email to