[
https://issues.apache.org/jira/browse/DRILL-561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13997777#comment-13997777
]
Krystal commented on DRILL-561:
-------------------------------
The following trim functions also failed with "Error: Missing function
implementation: [trim(VARCHAR-REQUIRED, VARCHAR-REQUIRED, VARBINARY-OPTIONAL)].
Full expression: --UNKNOWN EXPRESSION--.. ]"
select trim (leading name) from voter where rownum=20;
select trim(trailing name) from voter where rownum=20;
select trim(trailing name) from voter where rownum=20;
select trim(both 'n' from 'nixon') from voter where rownum=10;
select trim(both 'n' from 'nixon') from voter where rownum=10;
select trim(trailing 'n' from 'nixon') from voter where rownum=10;
> Drill fails to parse TRIM function
> ----------------------------------
>
> Key: DRILL-561
> URL: https://issues.apache.org/jira/browse/DRILL-561
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.0.0
> Reporter: Krystal
>
> The following TRIM function failed:
> select trim(name) from voter where rownum=20;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
> running query.[error_id: "06ab5b53-7781-44fb-ae8f-2c986065e952"
> endpoint {
> address: "qa-node57.qa.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < ValidationException:[
> java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 ] <
> IndexOutOfBoundsException:[ Index: 0, Size: 0 ]"
> ]
--
This message was sent by Atlassian JIRA
(v6.2#6252)
