Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

vertica place in version 8.0?

Hello,

 

We just upgraded our development instance from 7.2 to 8.0 and I cannot find the location of the geospatial functions (the placelib library). I understand this was included with the basic installation in 8.0. Previously, we had all of the Vertica Place functions installed in the public schema.

 

The errors we get are "doesn't exist or permission denied" (me) and "library was compiled with an incompatible SDK version [7.2.1]" (dbadmin account). I am trying to use the ST_GeomFromText function to update a geometry field of latitude and longitude positions. 

 

Any help is much appreciated...thanks!

 

-Jimmy

Comments

  • Hi Jimmy,

     

    For error 1, you may check in user_functions and grant permission to your users from dbadmin

    For error 2, you may need to re-install packages .

    Just check compare the packages using the below command 

    => SELECT lib_name, sdk_version FROM user_libraries;  

    and update the packages using  $ admintools -t install_package -d -P geospatial.

     

    Hope this helps

     

    Thanks

    Arun

  • Thanks, Arun...that did the trick. From my understanding the packages are supposed to upgrade with the 7.2 to 8.0 upgrade, but ours didn't. Everything is now working after we ran the command you mentioned. We also found reference information here:

     

    Documentation Link

     

    Thanks,

     

    -Jimmy

  • Hi Jimmy,

     

    I'm glad that your problem has been resolved.

    Hope HPE Vertica can add more value to your business.

     

    Cheers

    Arun

     

    I work for HPE Vertica

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.