We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


fcefparser() does not exist — Vertica Forum

fcefparser() does not exist

I'm using freshly installe Vertica 7.1.1-10 1TB Community Edition and trying to load cef file.

 

I'm getting ERROR: Function fcefparser() does not exist, or permission is denied for fcefparser().

 

I checked SELECT * FROM licenses; and got a confirmation that com.vertica.flextable is available.

I also checked SELECT * FROM user_library_manifest; and select * from user_libraries;

 

It looks like all the libraries are in place but I still can't use CEF loading :(

 

Any ideas?

 

Thanks!

Comments

  • Navin_CNavin_C Vertica Customer

     Hi MS440,

     

    First check if there is this function available in your systems table.

     

    select * from user_functions where function_name like '%fce%'

    If available then, which user are you using to run the COPY statement.

    It should always be a super user to load from a file.

     

     

  • Hi NC,

     

    Thanks for the quick response. I tried the 

     

    select * from user_functions where function_name like '%fce%;

     

    and it shows nothing. :( Then I tried

     

    select * from user_functions where function_name like '%FCef%;

     

    and this was successful. Thanks a lot!

     

     

  • Hi NC,

     

    After seeing the function in user_functions table I realized that I've been using the wrong namespace. While working in non-public schema I should use the full name of the function. Bottom line: there is no dependency on the case: FCefParser and fcefparser are both working just fine. The lesson learned: use the namespaces, like you always should!

     

    Thanks again!

Leave a Comment

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