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;
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center