[DRILL-2658] Add ilike and regex substring functions

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.0.0
• Component/s: Functions - Drill
• Assignee: Steven Phillips
• Reporter: Steven Phillips
• Created: 01/Apr/15 19:29
• Updated: 16/Jun/15 13:34
• Resolved: 15/Apr/15 20:36

Description

This will not modify the parser, so postgress syntax such as:

"... where c ILIKE '%ABC%'"

will not be currently supported. It will simply be a function:

"... where ILIKE(c, '%ABC%')"

Same for substring:

"select substr(c, 'abc')..."

will be equivalent to postgress

"select substr(c from 'abc')",

but 'abc' will be treated as a java regex pattern.

Issue Links

• relates to: DRILL-3301 ILIKE does not support escape characters.