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.
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