Issues with Function favroparser() when trying to do a COPY statement

  • KM03561005
  • 28-Nov-2019
  • 28-Nov-2019

This document is under revision.

Summary

By using the 10.0.24 DBViz jdbc Vertica jar, issue fixed in DBVix 9.x for permission denied when using farvoparser. [Code: 3457, SQL State: 42883] [Vertica][VJDBC](3457) ERROR: Function favroparser() does not exist, or permission is denied for favroparser() DBViz - vertica supported versions: ---------------------------------- Partner ProductDbVisualizer Free 10.0.13 and 10.0.14 Desktop PlatformWindows 10 Enterprise Vertica ClientJDBC 9.1.0 and 9.1.1 Vertica ServerVertica Database 9.1.0 and 9.1.1

Question

Hello Vertica,
User is trying to run the following command in our Vertica Database:
COPY nestedAvro FROM 'c:/Users/Fletcher/Desktop/nestedAvro.avro' PARSER favroparser(flatten_maps=FALSE);
And she is getting the following error:
[Code: 3457, SQL State: 42883]  
[Vertica][VJDBC](3457) ERROR: Function favroparser() does not exist, or permission is denied for favroparser()
We tried to give different grants to the user, but they were not sucessfull:
GRANT ALL ON "201852_GOBIA_ProductRepo".nestedAvro TO srvc_gobia_itg;
GRANT ALL ON LIBRARY public.FlexTableLib to srvc_gobia_itg;
Could you please help us find what's going on, Please?.
Thanks,
Jorge Hernandez.

Answer

Issue: [Code: 3457, SQL State: 42883]  [Vertica][VJDBC](3457) ERROR: Function favroparser() does not exist, or permission is denied for favroparser()

Solution:By using the 10.0.24 DBViz jdbc Vertica jar, issue fixed in DBVix 9.x for permission denied when using farvoparser.


DBViz - vertica supported versions:
----------------------------------
Partner ProductDbVisualizer Free 10.0.13 and 10.0.14
Desktop PlatformWindows 10 Enterprise
Vertica ClientJDBC 9.1.0 and 9.1.1
Vertica ServerVertica Database 9.1.0 and 9.1.1