[
https://issues.apache.org/jira/browse/DRILL-1099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055199#comment-14055199
]
Krystal commented on DRILL-1099:
--------------------------------
git.commit.id.abbrev=810a204
Verified that bug is fixed.
> ltrim and rtrim functions fail with SchemaChangeException
> -----------------------------------------------------------
>
> Key: DRILL-1099
> URL: https://issues.apache.org/jira/browse/DRILL-1099
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Reporter: Krystal
> Assignee: DrillCommitter
> Attachments:
> 0001-DRILL-1099-Inject-as-the-default-second-argument-to-.patch
>
>
> git.commit.id.abbrev=a1a6144
> ltrim and rtrim functions fail with SchemaChangeException if trim characters
> are missing.
> 0: jdbc:drill:schema=dfs> select ltrim(name) from voter where voter_id=20;
> message: "Screen received stop request sent. < SchemaChangeException:[
> Failure while trying to materialize incoming schema. Errors:
>
> Error in expression at index -1. Error: Missing function implementation:
> [ltrim(VARBINARY-OPTIONAL)]. Full expression: --UNKNOWN EXPRESSION--.. ]"
> ]
> The default string should be spaces.
> The following query works;
> select ltrim(name,' ') from voter where voter_id=20;
--
This message was sent by Atlassian JIRA
(v6.2#6252)
