Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Exposing Vertica log as external table for SQL access? Does anyone have a script with log parser?

At various customer sites, accessing and wading through the Vertica log and performing some log-analytics is fairly cumbersome and time-involved process. Even access is security sensitive and organizations are hesitant.
At few places we were copying the logs to NFS drives/share-points etc. Fairly inefficient.
Does anyone have a script (or pointers/starters) for SQL access to Vertica logs as External table with REGEX log parser included?
Any help/suggestions is greatly appreciated.
TIA
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
Maybe this discussion is helpful?
https://forum.vertica.com/discussion/239926/load-vertica-log-in-flex-table-and-also-evolve-a-regexp-function-to-identify-the-error-settings
AWESOME Thanks @Jim_Knicely !
Exactly, what I was looking for.