Oracle Query to Vertica Query conversion

Moderator: NorbertKrupa

Post Reply
rsaveetha
Newbie
Newbie
Posts: 5
Joined: Sat Oct 31, 2015 2:53 pm

Oracle Query to Vertica Query conversion

Post by rsaveetha » Thu Oct 20, 2016 6:58 am

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?

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1768
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Oracle Query to Vertica Query conversion

Post by JimKnicely » Mon Oct 24, 2016 7:14 pm

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?
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica SQL”