-
1. Re: Oracle Connector: LISTAGG function
shawkins Mar 28, 2017 6:03 PM (in response to jrod2016)LISTAGG is not directly supported. The equivalent is to use
STRINGAGG(last_name, ';') ORDER BY hire_date, last_name
Pushdown support for STRINGAGG is currently limited. If needed an
enhancement can be logged to be mapped to LISTAGG.
-
2. Re: Oracle Connector: LISTAGG function
jrod2016 Mar 29, 2017 10:12 AM (in response to shawkins)Logged a Jira ticket: [TEIID-4833] Oracle JDBC Connector: Support for LISTAGG - JBoss Issue Tracker
-
3. Re: Oracle Connector: LISTAGG function
shawkins Mar 29, 2017 10:16 AM (in response to jrod2016)Just to double check, the engine support would still be for stringagg and the JIRA would cover mapping that to LISTAGG for oracle pushdown correct?
-
4. Re: Oracle Connector: LISTAGG function
jrod2016 Mar 29, 2017 11:03 AM (in response to shawkins)The ideal scenario would be to support the Oracle LISTAGG syntax in the Teiid connector. However, if that's not possible at this time, we can go with pushdown of stringagg. This will require us to dynamically modify an oracle query to convert the listagg to stringagg before we deploy to Teiid.