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!
Recompiling the fjsonparser
Hi All,
I'm trying to load some json data with the fjsonparser but I've received the following error:
ERROR 6999: The library [FlexTableLib] for the function [fjsonparser()] was compiled with an incompatible SDK Version [v7.1.2-4]
HINT: Recompile the library with the SDK version [7.2.1] and then recreate the library and functions
I am running Vertica 7.2.1, but I have absolutely no idea where the source for fjsonparser might be, or how to recompile it. Any pointers would be greatly appreciated!
Thanks!
0
Comments
Hi!
1. Post full version of your Vertica instance(with minor fixes).
Hint: select version();
2. Post your OS distribution + version.
For example:
3. Post content of dir: /opt/vertica/packages/flextable/lib
For example:
3. Post md5sum of /opt/vertica/packages/flextable/lib/libvertica_flextable.so
For example:
4. Post output of file.
For example:
PS
>> but I have absolutely no idea where the source for fjsonparser might be
It's not open source, actuaally you can't recompile by yourself.
Disclimer: Im not a Vertica employee.
Hi,
You appear to have experienced an upgrade issue that we're currently investigating. You actually have the right version of Flex in /opt/vertica/packages, it just needs to get installed:
/opt/vertica/bin/admintools -T install_package -P default -d <database> -p <password>
Note: do not uninstall flex - there is no need to uninstall/install. Just install over the top of the existing old flex package.
Please let me know if this works.
-Ben