tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hyunsik Choi (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (TAJO-147) Implement trim(text), ltrim(text), and rtrim(text) function
Date Mon, 07 Oct 2013 05:24:41 GMT

     [ https://issues.apache.org/jira/browse/TAJO-147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Hyunsik Choi updated TAJO-147:

    Attachment: TAJO-147.patch

I've attached the trim string function.

In order to support SQL standard built-in string function, this patch improves and refactors
SQLParser.g. As a result, this implementation well follows SQL standard as follows:
trim([leading | trailing | both] [characters] from string)
For PostgreSQL compatibility, It also adds btim, ltrim, and rtrim function and some synonym
function 'trim' of btrim.

Besides, this patch also removes the legacy license from NOTICE.txt and LICENSE.txt for sql-frontend
that was removed few month ago.

> Implement trim(text), ltrim(text), and rtrim(text) function
> -----------------------------------------------------------
>                 Key: TAJO-147
>                 URL: https://issues.apache.org/jira/browse/TAJO-147
>             Project: Tajo
>          Issue Type: Sub-task
>          Components: operator/function/udf
>            Reporter: Hyunsik Choi
>            Assignee: Hyunsik Choi
>            Priority: Minor
>              Labels: newbie
>             Fix For: 0.2-incubating
>         Attachments: TAJO-147.patch
> We need to implement the below trim functions:
> * trim() function removes whitespaces in both sides
> * ltrim() function removes whitespaces in left side.
> * rtrim() function removes whitespaces in right side.

This message was sent by Atlassian JIRA

View raw message