The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
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