[jira] [Commented] (DRILL-2658) Add ilike and regex substring functions

["Chris Westin (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14391489#comment-14391489 ] 

Chris Westin commented on DRILL-2658:
-------------------------------------

Since this is really a new feature, let's move it to 1.0 if there are any significant hiccups with the patch; but if it's all OK, then we can leave it in 0.9.

> Add ilike and regex substring functions
> ---------------------------------------
>
>                 Key: DRILL-2658
>                 URL: https://issues.apache.org/jira/browse/DRILL-2658
>             Project: Apache Drill
>          Issue Type: New Feature
>          Components: Functions - Drill
>            Reporter: Steven Phillips
>            Assignee: Steven Phillips
>             Fix For: 0.9.0
>
>         Attachments: DRILL-2658.patch
>
>
> 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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)