You can translate the question and the replies:

json_object_agg

What is the equivalent for postgres function **json_object_agg(name, value)** function in Denodo ?
user
03-09-2020 12:18:15 -0400

1 Answer

Hi, Denodo allows users to extend the set of functions available in Virtual DataPort by creating custom functions. Hence, I would **create a custom function** that aggregates name/value pairs as a JSON object. As there is no predefined function in Denodo that is equivalent to** json_object_agg(name, value)** function. You can have a look at the section [Developing Custom Functions](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/developing_extensions/developing_custom_functions/developing_custom_functions#developing-custom-functions) of the Virtual DataPort Developer Guide to know more about how to create these custom functions. You can refer to the examples of custom functions located at ***<DENODOHOME>/samples/vdp/customFunctions***. Hope this helps!
Denodo Team
04-09-2020 08:21:05 -0400
You must sign in to add an answer. If you do not have an account, you can register here