Web Interface

openLooKeng provides a web interface for monitoring and managing queries. The web interface is accessible on the openLooKeng coordinator via HTTP, using the HTTP port number specified in the coordinator config_properties.

The main page has a list of queries along with information like unique query ID, query text, query state, percentage completed, username and source from which this query originated. The currently running queries are at the top of the page, followed by the most recently completed or failed queries.

The possible query states are as follows:

  • QUEUED -- Query has been accepted and is awaiting execution.
  • PLANNING -- Query is being planned.
  • STARTING -- Query execution is being started.
  • RUNNING -- Query has at least one running task.
  • BLOCKED -- Query is blocked and is waiting for resources (buffer space, memory, splits, etc.).
  • FINISHING -- Query is finishing (e.g. commit for autocommit queries).
  • FINISHED -- Query has finished executing and all output has been consumed.
  • FAILED -- Query execution failed.

The BLOCKED state is normal, but if it is persistent, it should be investigated. It has many potential causes: insufficient memory or splits, disk or network I/O bottlenecks, data skew (all the data goes to a few workers), a lack of parallelism (only a few workers available), or computationally expensive stages of the query following a given stage. Additionally, a query can be in the BLOCKED state if a client is not processing the data fast enough (common with "SELECT *" queries).

For more detailed information about a query, simply click the query ID link. The query detail page has a summary section, graphical representation of various stages of the query and a list of tasks. Each task ID can be clicked to get more information about that task.

The summary section has a button to kill the currently running query. There are two visualizations available in the summary section: task execution and timeline. The full JSON document containing information and statistics about the query is available by clicking the JSON link. These visualizations and other statistics can be used to analyze where time is being spent for a query.

General Properties

hetu.queryeditor-ui.allow-insecure-over-http

  • Type: boolean
  • Allowed values: true, false
  • Default value: false

Insecure authentication over HTTP is disabled by default. This could be overridden via hetu.queryeditor-ui.allow-insecure-over-http property of etc/config.properties (e.g. hetu.queryeditor-ui.allow-insecure-over-http=true).

hetu.queryeditor-ui.execution-timeout

  • Type: duration
  • Default value: 100 DAYS

UI Execution timeout is set to 100 days as default. This could be overridden via hetu.queryeditor-ui.execution-timeout of etc/config.properties

hetu.queryeditor-ui.max-result-count

  • Type: int
  • Default value: 1000

UI max result count is set to 1000 as default. This could be overridden via hetu.queryeditor-ui.max-result-count of etc/config.properties

hetu.queryeditor-ui.max-result-size-mb

  • Type: size
  • Default value: 1GB

UI max result size is set to 1 GB as default. This could be overridden via hetu.queryeditor-ui.max-result-size-mb of etc/config.properties

hetu.queryeditor-ui.session-timeout

  • Type: duration
  • Default value: 1 DAYS

UI session timeout is set to 1 day as default. This could be overridden via hetu.queryeditor-ui.session-timeout of etc/config.properties

hetu.queryhistory.max-count

  • Type: int
  • Default value: 1000

The maximum number of query history stored by openLooKeng. This could be overridden via “hetu.queryhistory.max-count” of “etc/config.properties”.

hetu.collectionsql.max-count

  • Type: int
  • Default value: 100

The Maximum number of SQL collected by each user. This could be overridden via “hetu.collectionsql.max-count” of “etc/config.properties”.

Remarks

The max length of the favorite SQL is 600 by default. You can modify it through the following steps:

  1. Login MySQL database according to the JDBC configuration of hetu-metastore.properties

  2. Select table hetu_favorite, execute script alter table hetu_favorite modify query varchar(2000) not null; to modify the max length of the favorite SQL.

有奖捉虫

“有虫”文档片段

0/500

存在的问题

文档存在风险与错误

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

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

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

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

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

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

内容描述不清晰

● 描述存在歧义;

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

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

内容获取有困难

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

示例代码有错误

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

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

内容有缺失

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

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

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

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

● 描述存在歧义

0/500

您对文档的总体满意度

非常不满意
非常满意

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

您的邮箱

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