The Vertica Database Forums

The function got created in vertica 6.0, it was working fine with version 6.0 , Now I have upgraded to vertica 6.1.1-0. The reference to the function stopped working. So i planned to build the library in 6.1 but i am getting following error while creating library.

ROLLBACK 3857: Library built with unsupported version of Vertica SDK [Version: v6.0.0-0, Revision: 94700]
HINT: Expected version: [Version: v6.1.1-0, Revision: 109264]

which one is it referring to ? is it referring to vertica.h, vertica.cpp from vertica 6.1 ? kindly Let me know your views

Hi,

I don't think that you can simply re-create the library with the CREATE LIBRARY command. First you need to re-compile the library file using thew new SDK.

See the programmer's guide, page 497:

When you have upgraded Vertica to a new version that contains changes to the SDK API. For your libraries to work with the new server version, you need to recompile them with new version of the SDK. See UDF Library Compatibility with New Server Versions (page 497) for more information."