how can i install group_concat

Peacherr

 

how can i install group_concat ?

Do you have how to set up step by step?

 

my version is 7.1.1

 

souce: http://vertica-howto.info/2014/09/how-to-transpose-your-data-in-vertica/

Adrian_Oprea_1

 The group_concat must be recompiled(make) using the libs you have on your server. As it was written in while back .

 

 

Example: recompile 

cd /opt/vertica/sdk/examples/AggregateFunctions/
g++ -D HAVE_LONG_INT_64 -I /opt/vertica/sdk/include -Wall -shared -Wno-unused-value \
-fPIC -o /tmp/Vertica-Extension-Packages-master/strings_package/lib/StringsLib.so /tmp/Vertica-Extension-Packages-master/strings_package/src/GroupConcat.cpp /opt/vertica/sdk/include/Vertica.cpp

 Create libs and transform function 

dbadmin=> CREATE LIBRARY StringsLib AS '/tmp/Vertica-Extension-Packages-master/strings_package/lib/StringsLib.so';
CREATE LIBRARY
dbadmin=> CREATE TRANSFORM FUNCTION group_concat  AS LANGUAGE 'C++' NAME 'GroupConcatFactory' LIBRARY StringsLib NOT FENCED;
CREATE TRANSFORM FUNCTION

that should be it ! 

 

SruthiA

Hi,

 

        You can download  the package from below URL 

 

https://github.com/vertica/Vertica-Extension-Packages/tree/master/strings_package

 

Once it is downloaded, copy it into your vertica cluster and install it

 

 

Sruthi