This is an automated email from the ASF dual-hosted git repository.
liaoxin pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 55bc79ba42a [doc](load) add routine load job system table doc (#2196)
55bc79ba42a is described below
commit 55bc79ba42a15dd75a0b9342e107bf5a62d6f8a3
Author: hui lai <1353307...@qq.com>
AuthorDate: Wed Apr 9 14:13:46 2025 +0800
[doc](load) add routine load job system table doc (#2196)
---
.../information_schema/routine_load_job.md | 58 ++++++++++++++++++++++
.../information_schema/routine_load_job.md | 58 ++++++++++++++++++++++
.../information_schema/routine_load_job.md | 58 ++++++++++++++++++++++
.../information_schema/routine_load_job.md | 58 ++++++++++++++++++++++
sidebars.json | 1 +
.../information_schema/routine_load_job.md | 58 ++++++++++++++++++++++
versioned_sidebars/version-3.0-sidebars.json | 1 +
7 files changed, 292 insertions(+)
diff --git
a/docs/admin-manual/system-tables/information_schema/routine_load_job.md
b/docs/admin-manual/system-tables/information_schema/routine_load_job.md
new file mode 100644
index 00000000000..a927d5c3710
--- /dev/null
+++ b/docs/admin-manual/system-tables/information_schema/routine_load_job.md
@@ -0,0 +1,58 @@
+---
+{
+ "title": "routine_load_job",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## Overview
+
+Used to view information about routine load jobs.
+
+## Database
+
+`information_schema`
+
+## Table Information
+
+| Column Name | Type | Description
|
+| :-------------------- | :-------- |
:----------------------------------------- |
+| JOB_ID | text | Job ID
|
+| JOB_NAME | text | Job name
|
+| CREATE_TIME | text | Job creation time
|
+| PAUSE_TIME | text | Job pause time
|
+| END_TIME | text | Job end time
|
+| DB_NAME | text | Database name
|
+| TABLE_NAME | text | Table name
|
+| STATE | text | Job status
|
+| CURRENT_TASK_NUM | text | Current number of subtasks
|
+| JOB_PROPERTIES | text | Job property configurations
|
+| DATA_SOURCE_PROPERTIES| text | Data source property configurations
|
+| CUSTOM_PROPERTIES | text | Custom property configurations
|
+| STATISTIC | text | Job statistics information
|
+| PROGRESS | text | Job progress information
|
+| LAG | text | Job delay information
|
+| REASON_OF_STATE_CHANGED| text | Reason for job status change
|
+| ERROR_LOG_URLS | text | Error log URLs
|
+| USER_NAME | text | Username
|
+| CURRENT_ABORT_TASK_NUM| int | Current number of failed tasks
|
+| IS_ABNORMAL_PAUSE | boolean | Whether paused by system (non-user pause)
|
\ No newline at end of file
diff --git
a/i18n/en/docusaurus-plugin-content-docs/current/admin-manual/system-tables/information_schema/routine_load_job.md
b/i18n/en/docusaurus-plugin-content-docs/current/admin-manual/system-tables/information_schema/routine_load_job.md
new file mode 100644
index 00000000000..84267864bf6
--- /dev/null
+++
b/i18n/en/docusaurus-plugin-content-docs/current/admin-manual/system-tables/information_schema/routine_load_job.md
@@ -0,0 +1,58 @@
+---
+{
+ "title": "routine_load_job",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## Overview
+
+Used to view information about routine load import jobs
+
+## Database
+
+`information_schema`
+
+## Table Information
+
+| Column Name | Type | Description
|
+| :-------------------- | :-------- |
:----------------------------------------- |
+| JOB_ID | text | Job ID
|
+| JOB_NAME | text | Job name
|
+| CREATE_TIME | text | Job creation time
|
+| PAUSE_TIME | text | Job pause time
|
+| END_TIME | text | Job end time
|
+| DB_NAME | text | Database name
|
+| TABLE_NAME | text | Table name
|
+| STATE | text | Job status
|
+| CURRENT_TASK_NUM | text | Current number of subtasks
|
+| JOB_PROPERTIES | text | Job property configurations
|
+| DATA_SOURCE_PROPERTIES| text | Data source property configurations
|
+| CUSTOM_PROPERTIES | text | Custom property configurations
|
+| STATISTIC | text | Job statistics information
|
+| PROGRESS | text | Job progress information
|
+| LAG | text | Job delay information
|
+| REASON_OF_STATE_CHANGED| text | Reason for job status change
|
+| ERROR_LOG_URLS | text | Error log URLs
|
+| USER_NAME | text | Username
|
+| CURRENT_ABORT_TASK_NUM| int | Current number of failed tasks
|
+| IS_ABNORMAL_PAUSE | boolean | Whether paused by system (non-user pause)
|
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/system-tables/information_schema/routine_load_job.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/system-tables/information_schema/routine_load_job.md
new file mode 100644
index 00000000000..dfbe2c98e5c
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/admin-manual/system-tables/information_schema/routine_load_job.md
@@ -0,0 +1,58 @@
+---
+{
+ "title": "routine_load_job",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## 概述
+
+用于查看routine load导入作业的信息
+
+## 所属数据库
+
+`information_schema`
+
+## 表信息
+
+| 列名 | 类型 | 说明 |
+| :--------------------- | :-------- | :--------------------------------------
|
+| JOB_ID | text | 作业 ID |
+| JOB_NAME | text | 作业名称 |
+| CREATE_TIME | text | 作业创建时间 |
+| PAUSE_TIME | text | 作业暂停时间 |
+| END_TIME | text | 作业结束时间 |
+| DB_NAME | text | 数据库名称 |
+| TABLE_NAME | text | 表名称 |
+| STATE | text | 作业状态 |
+| CURRENT_TASK_NUM | text | 当前子任务数量 |
+| JOB_PROPERTIES | text | 作业属性配置 |
+| DATA_SOURCE_PROPERTIES | text | 数据源属性配置 |
+| CUSTOM_PROPERTIES | text | 自定义属性配置 |
+| STATISTIC | text | 作业统计信息 |
+| PROGRESS | text | 作业进度信息 |
+| LAG | text | 作业延迟信息 |
+| REASON_OF_STATE_CHANGED| text | 作业状态变更原因 |
+| ERROR_LOG_URLS | text | 错误日志 URL |
+| USER_NAME | text | 用户名 |
+| CURRENT_ABORT_TASK_NUM | int | 当前失败的任务数量 |
+| IS_ABNORMAL_PAUSE | boolean | 是否非用户暂停 |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/admin-manual/system-tables/information_schema/routine_load_job.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/admin-manual/system-tables/information_schema/routine_load_job.md
new file mode 100644
index 00000000000..d0e13f4a3ec
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/admin-manual/system-tables/information_schema/routine_load_job.md
@@ -0,0 +1,58 @@
+---
+{
+ "title": "routine_load_job",
+ "language": "zh-CN"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## 概述
+
+用于查看routine load导入作业的信息, 从3.0.5版本引入这个特性。
+
+## 所属数据库
+
+`information_schema`
+
+## 表信息
+
+| 列名 | 类型 | 说明 |
+| :--------------------- | :-------- | :--------------------------------------
|
+| JOB_ID | text | 作业 ID |
+| JOB_NAME | text | 作业名称 |
+| CREATE_TIME | text | 作业创建时间 |
+| PAUSE_TIME | text | 作业暂停时间 |
+| END_TIME | text | 作业结束时间 |
+| DB_NAME | text | 数据库名称 |
+| TABLE_NAME | text | 表名称 |
+| STATE | text | 作业状态 |
+| CURRENT_TASK_NUM | text | 当前子任务数量 |
+| JOB_PROPERTIES | text | 作业属性配置 |
+| DATA_SOURCE_PROPERTIES | text | 数据源属性配置 |
+| CUSTOM_PROPERTIES | text | 自定义属性配置 |
+| STATISTIC | text | 作业统计信息 |
+| PROGRESS | text | 作业进度信息 |
+| LAG | text | 作业延迟信息 |
+| REASON_OF_STATE_CHANGED| text | 作业状态变更原因 |
+| ERROR_LOG_URLS | text | 错误日志 URL |
+| USER_NAME | text | 用户名 |
+| CURRENT_ABORT_TASK_NUM | int | 当前失败的任务数量 |
+| IS_ABNORMAL_PAUSE | boolean | 是否非用户暂停 |
diff --git a/sidebars.json b/sidebars.json
index 6c3c82d1df6..3774d2879ce 100644
--- a/sidebars.json
+++ b/sidebars.json
@@ -659,6 +659,7 @@
"admin-manual/system-tables/information_schema/profiling",
"admin-manual/system-tables/information_schema/referential_constraints",
"admin-manual/system-tables/information_schema/routines",
+
"admin-manual/system-tables/information_schema/routine_load_job",
"admin-manual/system-tables/information_schema/rowsets",
"admin-manual/system-tables/information_schema/schema_privileges",
"admin-manual/system-tables/information_schema/schemata",
diff --git
a/versioned_docs/version-3.0/admin-manual/system-tables/information_schema/routine_load_job.md
b/versioned_docs/version-3.0/admin-manual/system-tables/information_schema/routine_load_job.md
new file mode 100644
index 00000000000..37db4a0b0d7
--- /dev/null
+++
b/versioned_docs/version-3.0/admin-manual/system-tables/information_schema/routine_load_job.md
@@ -0,0 +1,58 @@
+---
+{
+ "title": "routine_load_job",
+ "language": "en"
+}
+---
+
+<!--
+Licensed to the Apache Software Foundation (ASF) under one
+or more contributor license agreements. See the NOTICE file
+distributed with this work for additional information
+regarding copyright ownership. The ASF licenses this file
+to you under the Apache License, Version 2.0 (the
+"License"); you may not use this file except in compliance
+with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing,
+software distributed under the License is distributed on an
+"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+KIND, either express or implied. See the License for the
+specific language governing permissions and limitations
+under the License.
+-->
+
+## Overview
+
+Used to view information about routine load jobs. This feature was introduced
in version 3.0.5.
+
+## Database
+
+`information_schema`
+
+## Table Information
+
+| Column Name | Type | Description
|
+| :-------------------- | :-------- |
:----------------------------------------- |
+| JOB_ID | text | Job ID
|
+| JOB_NAME | text | Job name
|
+| CREATE_TIME | text | Job creation time
|
+| PAUSE_TIME | text | Job pause time
|
+| END_TIME | text | Job end time
|
+| DB_NAME | text | Database name
|
+| TABLE_NAME | text | Table name
|
+| STATE | text | Job status
|
+| CURRENT_TASK_NUM | text | Current number of subtasks
|
+| JOB_PROPERTIES | text | Job property configurations
|
+| DATA_SOURCE_PROPERTIES| text | Data source property configurations
|
+| CUSTOM_PROPERTIES | text | Custom property configurations
|
+| STATISTIC | text | Job statistics information
|
+| PROGRESS | text | Job progress information
|
+| LAG | text | Job delay information
|
+| REASON_OF_STATE_CHANGED| text | Reason for job status change
|
+| ERROR_LOG_URLS | text | Error log URLs
|
+| USER_NAME | text | Username
|
+| CURRENT_ABORT_TASK_NUM| int | Current number of failed tasks
|
+| IS_ABNORMAL_PAUSE | boolean | Whether paused by system (non-user pause)
|
\ No newline at end of file
diff --git a/versioned_sidebars/version-3.0-sidebars.json
b/versioned_sidebars/version-3.0-sidebars.json
index 62fd0db1d74..ac7567adc1b 100644
--- a/versioned_sidebars/version-3.0-sidebars.json
+++ b/versioned_sidebars/version-3.0-sidebars.json
@@ -629,6 +629,7 @@
"admin-manual/system-tables/information_schema/profiling",
"admin-manual/system-tables/information_schema/referential_constraints",
"admin-manual/system-tables/information_schema/routines",
+
"admin-manual/system-tables/information_schema/routine_load_job",
"admin-manual/system-tables/information_schema/rowsets",
"admin-manual/system-tables/information_schema/schema_privileges",
"admin-manual/system-tables/information_schema/schemata",
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
