5.19. System Connector

The System connector doesn’t need to be configured: it is automaticallyavailable via a catalog named .

List the available system schemas:

List the tables in one of the schemas:

Kill a running query:

The catalogs table contains the list of available catalogs.

metadata.schema_properties

The schema properties table contains the list of available propertiesthat can be set when creating a new schema.

runtime.nodes

The nodes table contains the list of visible nodes in the Prestocluster along with their status.

The queries table contains information about currently and recentlyrunning queries on the Presto cluster. From this table you can find outthe original query text (SQL), the identity of the user who ran the queryand performance information about the query including how long the querywas queued and analyzed.

runtime.tasks

The tasks table contains information about the tasks involved in aPresto query including where they were executed and and how many rowsand bytes each task processed.

• Kill the query identified by . The query failure messagewill include the specified .