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

[Don Krapohl (JIRA)]

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

Don Krapohl commented on TEIID-4422:
------------------------------------

Steve,

I am requesting that concat function does support varargs in the translator.  I'd also request that the concat_ws be added as well because it allows the concat delimiter.

If I can find a few minutes next week I may pull this story and do a push request if I have time.

Thanks!

Don

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