drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steven Phillips (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2658) Add ilike and regex substring functions
Date Wed, 01 Apr 2015 19:29:53 GMT
Steven Phillips created DRILL-2658:
--------------------------------------

             Summary: Add ilike and regex substring functions
                 Key: DRILL-2658
                 URL: https://issues.apache.org/jira/browse/DRILL-2658
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Steven Phillips


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)

Mime
View raw message