Loaded string package UDF extensions to Vertica database. This adds, among others, the group_concat() function to Vertica SQL.
This is working fine for users using VSQL, WinSQL and Squirrel SQL clients. However, users with Toad Data Point 3.7 get this error when trying to use the new function:
Error:8/6/2015 12:33:52 PM 0:00:00.040: ERROR 3457: Function group_concat(varchar) does not exist, or permission is denied for group_concat(varchar)
HINT: No function matches the given name and argument types. You may need to add explicit type casts
3: select group_concat(node_name) over () from nodes
The Vertica driver version is: 6.01.03. The Vertica version is Vertica Analytic Database v7.1.1-10
Test sql:
select group_concat(node_name) over () from nodes;
Toad cannot find the UDF. Try fully qualifying the name of the function and add argument. See example below:
/*Executing procedure ApproxCountDistinct5PCT
*/
SELECT public.ApproxCountDistinct5PCT (1)