drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-561) Drill fails to parse TRIM function
Date Wed, 14 May 2014 17:07:16 GMT

    [ 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)

Mime
View raw message