[teiid-issues] [JBoss JIRA] (TEIID-4422) Impala Translator - add pushdown support for concat and concat_ws functions

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4422?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13290100#comment-13290100 ] 

Steven Hawkins commented on TEIID-4422:
---------------------------------------

Have a look and see if https://github.com/teiid/teiid/commit/6dec6af3c08154757dbab6ab58e80d2b78023d34 meets your needs.  It doesn't alter the Teiid system functions, but does update the impala support.

> Impala Translator - add pushdown support for concat and concat_ws functions
> ---------------------------------------------------------------------------
>
>                 Key: TEIID-4422
>                 URL: https://issues.jboss.org/browse/TEIID-4422
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: JDBC Connector
>    Affects Versions: 9.0.2
>            Reporter: Don Krapohl
>            Assignee: Steven Hawkins
>
> As a consumer I need the concat and concat_ws function definitions with matching signatures in line with http://www.cloudera.com/documentation/archive/impala/2-x/2-0-x/topics/impala_string_functions.html
> concat:
> concat(string a, string b...)
> Purpose: Returns a single string representing all the argument values joined together.
> Return type: string
> Usage notes: concat() and concat_ws() are appropriate for concatenating the values of multiple columns within the same row, while group_concat() joins together values from different rows.
> concat_ws:
> concat_ws(string sep, string a, string b...)
> Purpose: Returns a single string representing the second and following argument values joined together, delimited by a specified separator.
> Return type: string
> Usage notes: concat() and concat_ws() are appropriate for concatenating the values of multiple columns within the same row, while group_concat() joins together values from different rows.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)