You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2014/07/02 20:29:25 UTC

[jira] [Created] (DRILL-1099) ltrim and rtrim functions fail with SchemaChangeException

Krystal created DRILL-1099:
------------------------------

             Summary: 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


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)