The esp_query utility sends snapshot SQL
queries to be applied to ESP output windows.
The ODBC driver and JDBC driver can be used for on-demand queries.
SQL Syntax in Event Stream Processor
The ESP On-Demand Query interface allows you to query active windows in a running ESP project using the esp_query tool or the ODBC or JDBC driver.
esp_query
Executes an SQL statement, supplied by standard input or the -Q option, on the server and prints the results to the standard output.