> ANSI SQL doesn't define regex operator. > Drill neither. > Drill has SQL functions extension like "REPEATED_CONTAINS" that looks to handle regex. regex operator could be replaced with one new SQL extension ? I guess I could create my own functions in java, right ? Maybe push it into github then ?
> Doesn't it enough 'LIKE' operator? > Sadly not, I'am looking for complex pattern matching. -- > Miura, Masahide > > -----Original Message----- > From: Nicolas Paris [mailto:[email protected]] > Sent: Tuesday, February 02, 2016 9:04 PM > To: [email protected] > 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, >
