Krystal created DRILL-739:
-----------------------------
Summary: 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
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)
