Skip to main content

Exposing Vertica log as external table for SQL access? Does anyone have a script with log parser?

  • December 20, 2020
  • 2 replies
  • 6 views

Sudhakar_B
Forum|alt.badge.img+1

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

2 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • December 21, 2020

Sudhakar_B
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • December 21, 2020

AWESOME Thanks @Jim_Knicely !
Exactly, what I was looking for.