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,