[DRILL-739] SUBSTRING function with regex pattern fails to parse.

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Functions - Drill
• Assignee: Unassigned
• Reporter: Krystal
• Created: 14/May/14 16:52
• Updated: 01/Oct/15 16:37

Description

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;