Hi,
I am working on a DB migration project, in which the database is getting migrated from Oracle to Vertica, which also includes the conversion of PL/SQL procedures for vertica.(I am doing this in java with vertica SQL and JDBC).
One of the procedure is having a query like >>"select rtrim(xmlagg(xmlelement(e, group_desc||',')).extract('//text()'),',') from <table> where id in();" Do we have an equivalent function in vertica for xmlagg? or how this can be implemented in vertica?
Oracle Query to Vertica Query conversion
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Oracle Query to Vertica Query conversion
Hi,
There is not an xmlagg function in Vertica yet, but there is an XML extension package available here:
https://github.com/vertica/Vertica-Exte ... ml_package
Maybe the "XSLT function" that is included can help?
There is not an xmlagg function in Vertica yet, but there is an XML extension package available here:
https://github.com/vertica/Vertica-Exte ... ml_package
Maybe the "XSLT function" that is included can help?
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.