System Connector

The System connector provides information and metrics about the currently running openLooKeng cluster. It makes this available via normal SQL queries.

Configuration

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

Using the System Connector

List the available system schemas:

SHOW SCHEMAS FROM system;

List the tables in one of the schemas:

SHOW TABLES FROM system.runtime;

Query one of the tables:

SELECT * FROM system.runtime.nodes;

Kill a running query:

CALL system.runtime.kill_query(query_id => '20151207_215727_00146_tx3nr', message => 'Using too many resources');

System Connector Tables

metadata.catalogs

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.

metadata.table_properties

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.nodes

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

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.

runtime.tasks

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.

System Connector Procedures

runtime.kill_query(query_id, message)

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

有奖捉虫

“有虫”文档片段

0/500

存在的问题

文档存在风险与错误

● 拼写,格式,无效链接等错误;

● 技术原理、功能、规格等描述和软件不一致,存在错误;

● 原理图、架构图等存在错误;

● 版本号不匹配:文档版本或内容描述和实际软件不一致;

● 对重要数据或系统存在风险的操作,缺少安全提示;

● 排版不美观,影响阅读;

内容描述不清晰

● 描述存在歧义;

● 图形、表格、文字等晦涩难懂;

● 逻辑不清晰,该分类、分项、分步骤的没有给出;

内容获取有困难

● 很难通过搜索引擎,openLooKeng官网,相关博客找到所需内容;

示例代码有错误

● 命令、命令参数等错误;

● 命令无法执行或无法完成对应功能;

内容有缺失

● 关键步骤错误或缺失,无法指导用户完成任务,比如安装、配置、部署等;

● 逻辑不清晰,该分类、分项、分步骤的没有给出

● 图形、表格、文字等晦涩难懂

● 缺少必要的前提条件、注意事项等;

● 描述存在歧义

0/500

您对文档的总体满意度

非常不满意
非常满意

请问是什么原因让您参与到这个问题中

您的邮箱

创Issue赢奖品
根据您的反馈,会自动生成issue模板。您只需点击按钮,创建issue即可。
有奖捉虫