 Query Engine

The query engine does the work of breaking down a SQL query and executing it.

Restarting the engine

When you add a new data source to EdgeSet, you must restart the query engine in order for EdgeSet to connect to the data source and map the data into the catalog.

Engine stats

Clicking on the ratio¹ next to the user menu will show you statistics about the query engine, such as the number of running and queued queries.

¹ A ratio like 0/2 shows the number of currently active queries (i.e. 0) and the total number of query slots (i.e. 2).

No user queries have run on this EdgeSet server yet

You can restart the query engine any time from this page.

Query Management

You can view and manage currently running or queued queries in the User Queries and System Queries tables.

User Queries

The User Queries table will display the list of currently running or queued queries executed by users of Edgeset with the following details:

Submitted: The date and time in which the query was submitted (displayed in your local timezone)
User: The user running the query
Query: The query string
Status: Status of the query
Action: Display’s a cancellation link to cancel the associated query

System Queries

The System Queries table displays the list of currently running or queued queries executed by the Edgeset user interface (such as for displaying the data catalog). System queries are special in that they don’t count towards the concurrent query limit and are executed as soon as possible.

Note: Unless necessary it’s advisable not to cancel the displayed system queries as it could lead to unexpected errors for users.

Logs

If adding a data source doesn’t work as expected, you can open the Logs to view log messages.

Opening the Logs

Open the logs by clicking on Logs icon in the menu, a panel will pop out from the bottom of the page.

Note that only the last 1000 log entries are displayed.