[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=13287051#comment-13287051 ] 

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

Our concat system function does currently push down to impala, but does not expect varargs - are you requesting that the Teiid system function supports varargs?

Similarly are you requesting that a concat_ws system function be added?  Or is it sufficient to just add concat_ws to the pushdown functions exposed by the translator?

For group_concat, we can map that to the pushdown of the Teiid string_agg function. 

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