System Connector

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

    List the available system schemas:

    List the tables in one of the schemas:

    Query one of the tables:

    The catalogs table contains the list of available catalogs.

    metadata.schema_properties

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

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

    runtime.nodes

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

    runtime.tasks

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

    The transactions table contains the list of currently open transactions and related metadata. This includes information such as the create time, idle time, initialization parameters, and accessed catalogs.

    runtime.kill_query(query_id, message)

    Kill the query identified by query_id. The query failure message will include the specified message.