]
Steven Hawkins resolved TEIID-4422.
-----------------------------------
Fix Version/s: 9.1
Resolution: Done
Marking as resolved. We can also look into adding a concat_ws system function, but
unfortunately the null handling varies by vendor - postgresql/mysql skip non-separator
nulls, but impala makes the whole result null.
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
Fix For: 9.1
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.