how can i install group_concat

Comments

• Options

  Adrian_Oprea_1

  April 2016

   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 ! 

   

  0
• Options

  SruthiA Vertica Employee Administrator

  April 2016

  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

  0