[jira] [Updated] (DRILL-739) SUBSTRING function with regex pattern fails to parse.

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau updated DRILL-739:
---------------------------------
    Issue Type: New Feature  (was: Bug)

> SUBSTRING function with regex pattern fails to parse.
> -----------------------------------------------------
>
>                 Key: DRILL-739
>                 URL: https://issues.apache.org/jira/browse/DRILL-739
>             Project: Apache Drill
>          Issue Type: New Feature
>          Components: Functions - Drill
>            Reporter: Krystal
>            Assignee: Cliff Buchanan
>             Fix For: Future
>
>
> SUBSTRING(string from pattern) function fails to execute.  For example:
> select substring(name from '^.....') from voter where age < 20;
> message: "Failure while parsing sql. < ValidationException:[ org.eigenbase.util.EigenbaseContextException: From line 1, column 8 to line 1, column 36 ] < EigenbaseContextException:[ From line 1, column 8 to line 1, column 36 ] < SqlValidatorException:[ Cannot apply 'SUBSTRING' to arguments of type 'SUBSTRING(<ANY> FROM <CHAR(6)>)'. Supported form(s): 'SUBSTRING(<CHAR> FROM <INTEGER>)'
> 'SUBSTRING(<CHAR> FROM <INTEGER> FOR <INTEGER>)'
> 'SUBSTRING(<VARCHAR> FROM <INTEGER>)'
> 'SUBSTRING(<VARCHAR> FROM <INTEGER> FOR <INTEGER>)'
> 'SUBSTRING(<BINARY> FROM <INTEGER>)'
> 'SUBSTRING(<BINARY> FROM <INTEGER> FOR <INTEGER>)'
> 'SUBSTRING(<VARBINARY> FROM <INTEGER>)'
> 'SUBSTRING(<VARBINARY> FROM <INTEGER> FOR <INTEGER>)' ]"
> ]
> Same error for the following test queries:
> select substring(name from 's.n$') from student where rownum=105;
> select substring(name from '^[A-Z].*$') from voter where rownum=15;



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