Skip to main content

Why some queries don't appear in Vertica's query history

  • March 7, 2019
  • 0 replies
  • 0 views

abtsantosbenten
Forum|alt.badge.img+1

After running an ETL process, the jobs' query didn't appear in the query_profiles or the query_requests catalog. What happened? Proof that the query ran are the vsql (called via shell script files) output log files that contain results of the query. How can we ensure that the queries get logged to the catalog tables for monitoring? Thanks.