Vertica strings_packge( and group_concat) Upgrade
Hi,
For an unknown reason, I've getting the below error:
ERROR 6999: The library [GroupConcatLib] for the function [group_concat(varchar)] was compiled with an incompatible SDK Version [v6.1.0-0]
HINT: Recompile the library with the SDK version [7.2.1] and then recreate the library and functions
I've cloned Vertica-Extension-Packages and ran:
cd strings-package
make install
Got the below output:==============================================
vsql -f ddl/install.sql
Password:
version
------------------------------------
Vertica Analytic Database v7.2.1-0
(1 row)
CREATE LIBRARY
CREATE FUNCTION
CREATE FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE TRANSFORM FUNCTION
CREATE FUNCTION
CREATE TRANSFORM FUNCTION
vsql:ddl/install.sql:16: ROLLBACK 3472: Function with same name and number of parameters already exists: group_concat
==============================================
Tried also to run 'make uninstall' followed by 'make install' but it didn't help.
Thanks in advance,
Yarden
0
Comments
HI,
Please try by runing make command before installing strings package using install.sql
Sruthi
Hi,
Got the same error:
vsql:ddl/install.sql:16: ROLLBACK 3472: Function with same name and number of parameters already exists: group_concat
I've dropped the manually install GroupConcat library and successfully installed the strings_package.
Queries runs normally now
Thank you!
Hello,
Running into issue like this -
make: Entering directory
/opt/vertica/packages/Vertica-Extension-Packages-master/strings_package' g++ -g -D HAVE_LONG_LONG_INT_64 -c -I ../include -Wall -Wno-unused-value -fPIC -I /opt/vertica/sdk/include -I /opt/vertica/packages/Vertica-Extension-Packages-master/strings_package/src/third-party/include -O3 -DNDEBUG /opt/vertica/sdk/include/Vertica.cpp -o build/Vertica.o In file included from /opt/vertica/sdk/include/Vertica.h:75:0, from /opt/vertica/sdk/include/Vertica.cpp:38: /opt/vertica/sdk/include/VerticaUDx.h: In member function ‘void Vertica::UDXObject::cancelUDX(Vertica::ServerInterface&)’: /opt/vertica/sdk/include/VerticaUDx.h:2305:57: error: operand type ‘bool*’ is incompatible with argument 1 of ‘__sync_fetch_and_or’ if (!__sync_fetch_and_or(&(this->canceled), true)) { ^ make: *** [build/Vertica.o] Error 1 make: Leaving directory/opt/vertica/packages/Vertica-Extension-Packages-master/strings_package'We have upgraded to 9.2 and just installing the extension packages, running into this error.
When executing group_concat, the error is -
The library [StringsLib] for the function [group_concat(varchar)] was compiled with an incompatible SDK Version [8.1.1].
Any pointers please? Thanks!
We are facing the below error after upgrading to 9.2.1-3:
[Code: 3399, SQL State: VP001] [Vertica]VJDBC ROLLBACK: Failure in UDx RPC call InvokeGetLibraryInfo(): Error calling setupExecContext() in User Defined Object [] at [/data/qb_workspaces/jenkins2/ReleaseBuilds/Grader/REL-9_2_1-x_grader/build/vertica/OSS/UDxFence/vertica-udx-C++.cpp:274], error code: 0, message: Error happened in dlopen(): [/outbrain/vertica/home/udx/Vertica-Extension-Packages/strings_package/lib/StringsLib.so: cannot open shared object file: No such file or directory]
@AnitaM77 - were you able to solve this?
You will need to recompile UDx Libraries everytime you upgrade Vertica.
See:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ExtendingVertica/UDx/UpdatingUDFsAfterAServerUpgrade.htm
As an alternative to GROUP_CONCAT, take a peek at the LISTAGG function. You won't need to recompile it!
See:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Aggregate/LISTAGG.htm