STRING_AGG function in SAP HANA SQL Script

[Former Member]

Hi,

We have HANA Revision 7.3.

STRING_AGG function seems to work when we just execute the query without assinging it to the value.

However as soon as we assign it to a value in a stored procedure or scripted Calcuation view, it fails.

Any ideas?

Thanks,

Hyun

[ruediger_karl]

Hi,

please note that the STRING_AGG() function will not be supported earlier than SPS09. So, you found an undocumented feature. For now the feature is intended for SAP-internal usage only.

Regards, Ruediger

[Former Member]

It seems STRING_AGG appeared in the latest SAP HANA SQL Reference. Expressions - SAP HANA SQL and System Views Reference - SAP Library

[lbreddemann]

Yes, as usual the documentation production is asynchronous with the actual product.

As long as product management, here represented by Ruediger doesn't release the feature officially it will stay in this half-supported state...

[ruediger_karl]

Hi,

good news. The STRING_AGG() feature has been released earlier than expected. It is now officially supported - rev82 onwards.

Regards, Ruediger

[Former Member]

It will be a cool feature if STRING_AGG function is included in the list of

Semantic-> Columns panel -> Aggregate (list)  

[Former Member]

That would be awesome!

+1 on this idea

[former_member184969]

I Just putted it in the idea place. I think it's time to advertise 🙂

[former_member184969]

Hi

The STRING_AGG functions seems a bit limited by the fact that the <delimiter> has to be a constant. Is there any plan to make it compliant with variables or functions(like CHAR(13) ?

Thanks.

[Astrid_Gambill]

Assuming you mean this - https://ideas.sap.com/D35515 - I just gave it a thumbs up.