group_concat of flex table values issue



I have a flex table and I am trying to concatenate values using :-


set search_path to public;

select , group_concat(a.values) OVER (PARTITION BY
from (
select __identity__ as id, mapitems(sourceGroups) OVER(PARTITION BY __identity__) from testJSON
) a;


I get the error :-


 16:46:15  [SELECT - 0 row(s), 0.000 secs]  [Error Code: 2858, SQL State: VP001]  [Vertica][VJDBC](2858) ERROR: Could not find function definition


The group_concat function is there in our public schema.





I can select the value and a.values I just can't seem to do a group_concat.


I have googled for a soluiton but come up blank.


Any ideas?





  • Navin_CNavin_C Vertica Customer

    Are you able to use this funciton on regular tables.


    Can you try this:

    select group_concat(node_name) over () from nodes;


    Hope this helps.


  • Hi Navin,


    Sp this is strange - I made sure everyone had access to the group_concat in the 'public' scheme by doing a grant to public (i.e everyone). The command still failed with the same message


    It turns out we have the same group_concat finction in a different schema and if I referenced that - it worked fine.


    So I guess my issue is resolved but it strange the 'public' schema version did not work.


    Thanks for your help.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file