[
https://issues.apache.org/jira/browse/DRILL-739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Cliff Buchanan reassigned DRILL-739:
------------------------------------
Assignee: Cliff Buchanan (was: Mehant Baid)
> 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: Bug
> Components: Functions - Drill
> Reporter: Krystal
> Assignee: Cliff Buchanan
> Fix For: 1.0.0-BETA1
>
>
> 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.2#6252)
