System Connector

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

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.

metadata.table_comments

The table comments table contains the list of table comment.

runtime.queries

The queries table contains information about currently and recently running queries on the openLooKeng cluster. From this table you can find out the original query text (SQL), the identity of the user who ran the query and performance information about the query including how long the query was queued and analyzed.

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

runtime.transactions

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)