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

how can i install group_concat

 

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/

Comments

  •  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 ! 

     

  • SruthiASruthiA Employee

    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

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.