This article provides information on how the user's query can be retrieved from the Vertica database.
Environment:
Vertica Analytics Database: v11.0.1-x
Situation:
How the user's executed query retrieved from the Vertica database?
Resolution:
The "request" column is to store query on query_requests view. Query requests is a system view on top of multiple DC tables. Query can be retrieved from dc_requests_issued table using transaction_id and statement_id too.
