drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-739) SUBSTRING function with regex pattern fails to parse.
Date Wed, 14 May 2014 16:53:21 GMT
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)

Mime
View raw message