Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How to access LISTAGG or GROUP_CONCAT in Vertica 9.3?

edited November 19 in General Discussion

How to install and access LISTAGG or GROUP_CONCAT in Vertica 9.3? I'm under the impression the LISTAGG is standard in 9.2 and the .cpp files were available in 7.1.

=> SELECT VERSION();
              VERSION               
------------------------------------
 Vertica Analytic Database v9.3.1-8
(1 row)
=> SELECT manufact, LISTAGG(model) FROM test.car_sales GROUP BY manufact;
ERROR 3457:  Function LISTAGG(varchar) does not exist, or permission is denied for LISTAGG(varchar)
HINT:  No function matches the given name and argument types. You may need to add explicit type casts
=> SELECT manufact, GROUP_CONCAT(model) FROM test.car_sales GROUP BY 1;
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

Best Answer

Answers

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.