Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Is there a corresponding antlr4 file to implement Vertica SQL parsing?
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Answers
If your g4 files format is similar to JSON try the Vertica FJSONPARSER parser which parses and loads JSON files.
Those JSON files can contain either repeated JSON data objects including nested maps, or an outer list of JSON elements.
See: https://www.vertica.com/docs/11.0.x/HTML/Content/Authoring/SQLReferenceManual/Statements/COPY/FJSONPARSER.htm
In addition you can use user-defined parser functions to parse data in formats not understood by the Vertica built-in parser.
See: https://www.vertica.com/docs/11.0.x/HTML/Content/Authoring/ExtendingVertica/UDx/UDL/UDLParser.htm
Thank you very much for the advice, but I just need the Vertica SQL's g4 syntax file written by antlr4