[teiid-issues] [JBoss JIRA] (TEIID-4422) Impala Translator - add pushdown support for concat and concat_ws functions
[
https://issues.jboss.org/browse/TEIID-4422?page=com.atlassian.jira.plugin...
]
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/imp...
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)