This is an automated email from the ASF dual-hosted git repository. jiafengzheng 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 96324cdb5ab fix docs 404 url (#122) 96324cdb5ab is described below commit 96324cdb5abc3dbc13cc2d83a0c66d0c48681a00 Author: zy-kkk <zhong...@qq.com> AuthorDate: Sat Oct 8 17:12:11 2022 +0800 fix docs 404 url (#122) Update SHOW-ALTER-TABLE-MATERIALIZED-VIEW.md --- docs/ecosystem/logstash.md | 4 +- docs/ecosystem/udf/contribute-udf.md | 10 +- docs/faq/install-faq.md | 1 - .../Load/CREATE-SYNC-JOB.md | 2 +- .../SHOW-ALTER-TABLE-MATERIALIZED-VIEW.md | 120 +++++++++++++++++++++ .../sql-reference/Show-Statements/SHOW-STATUS.md | 86 +-------------- .../current/ecosystem/logstash.md | 4 +- .../Alter/ALTER-TABLE-ROLLUP.md | 2 +- .../Load/CREATE-SYNC-JOB.md | 2 +- 9 files changed, 136 insertions(+), 95 deletions(-) diff --git a/docs/ecosystem/logstash.md b/docs/ecosystem/logstash.md index dbf7901625e..c6ab151d1f4 100644 --- a/docs/ecosystem/logstash.md +++ b/docs/ecosystem/logstash.md @@ -28,9 +28,9 @@ under the License. This plugin is used to output data to Doris for logstash, use the HTTP protocol to interact with the Doris FE Http interface, and import data through Doris's stream load. -[Learn more about Doris Stream Load ](../../data-operate/import/import-way/stream-load-manual) +[Learn more about Doris Stream Load ](../data-operate/import/import-way/stream-load-manual) -[Learn more about Doris](../) +[Learn more about Doris](/) ## Install and compile diff --git a/docs/ecosystem/udf/contribute-udf.md b/docs/ecosystem/udf/contribute-udf.md index 1db7a8b9642..0492c7e0139 100644 --- a/docs/ecosystem/udf/contribute-udf.md +++ b/docs/ecosystem/udf/contribute-udf.md @@ -14,7 +14,7 @@ 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 + 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 @@ -73,8 +73,8 @@ The user manual needs to include: UDF function definition description, applicabl ``` ├── docs - │ └── zh-CN - │ └──extending-doris + │ └── zh-CN + │ └──extending-doris │ └──udf │ └──contrib │ ├── udf-simple-manual.md @@ -83,8 +83,8 @@ The user manual needs to include: UDF function definition description, applicabl ``` ├── docs - │ └── en - │ └──extending-doris + │ └── en + │ └──extending-doris │ └──udf │ └──contrib │ ├── udf-simple-manual.md diff --git a/docs/faq/install-faq.md b/docs/faq/install-faq.md index d877c6adc0e..e945ceb6c79 100644 --- a/docs/faq/install-faq.md +++ b/docs/faq/install-faq.md @@ -155,7 +155,6 @@ In many cases, we need to troubleshoot problems through logs. The format and vie Logs starting with F are Fatal logs. For example, F0916 , indicating the Fatal log on September 16th. Fatal logs usually indicate a program assertion error, and an assertion error will directly cause the process to exit (indicating a bug in the program). Welcome to the WeChat group, github discussion or dev mail group for help. - 2. FE FE is a java process, and the robustness is due to the C/C++ program. Usually the reason for FE to hang up may be OOM (Out-of-Memory) or metadata write failure. These errors usually have an error stack in fe.log or fe.out. Further investigation is required based on the error stack information. diff --git a/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Load/CREATE-SYNC-JOB.md b/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Load/CREATE-SYNC-JOB.md index 09302c36e4e..99b592c7619 100644 --- a/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Load/CREATE-SYNC-JOB.md +++ b/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Load/CREATE-SYNC-JOB.md @@ -36,7 +36,7 @@ The data synchronization (Sync Job) function supports users to submit a resident Currently, the data synchronization job only supports connecting to Canal, obtaining the parsed Binlog data from the Canal Server and importing it into Doris. -Users can view the data synchronization job status through [SHOW SYNC JOB](../../Show-Statements/SHOW-SYNC-JOB). +Users can view the data synchronization job status through [SHOW SYNC JOB](../../../../sql-manual/sql-reference/Show-Statements/SHOW-SYNC-JOB). grammar: diff --git a/docs/sql-manual/sql-reference/Show-Statements/SHOW-ALTER-TABLE-MATERIALIZED-VIEW.md b/docs/sql-manual/sql-reference/Show-Statements/SHOW-ALTER-TABLE-MATERIALIZED-VIEW.md index e69de29bb2d..7a75f9a94af 100644 --- a/docs/sql-manual/sql-reference/Show-Statements/SHOW-ALTER-TABLE-MATERIALIZED-VIEW.md +++ b/docs/sql-manual/sql-reference/Show-Statements/SHOW-ALTER-TABLE-MATERIALIZED-VIEW.md @@ -0,0 +1,120 @@ +--- +{ + "title": "SHOW ALTER TABLE MATERIALIZED VIEW", + "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. +--> + +## SHOW ALTER TABLE MATERIALIZED VIEW + +### Name + +SHOW ALTER TABLE MATERIALIZED VIEW + +### Description + +This command is used to view the execution of the Create Materialized View job submitted through the [CREATE-MATERIALIZED-VIEW](../Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW) statement. + +> This statement is equivalent to `SHOW ALTER TABLE ROLLUP`; + +```sql +SHOW ALTER TABLE MATERIALIZED VIEW +[FROM database] +[WHERE] +[ORDER BY] +[LIMIT OFFSET] +```` + +- database: View jobs under the specified database. If not specified, the current database is used. +- WHERE: You can filter the result column, currently only the following columns are supported: + - TableName: Only equal value filtering is supported. + - State: Only supports equivalent filtering. + - Createtime/FinishTime: Support =, >=, <=, >, <, != +- ORDER BY: The result set can be sorted by any column. +- LIMIT: Use ORDER BY to perform page-turning query. + +Return result description: + +```sql +mysql> show alter table materialized view\G +**************************** 1. row ******************** ****** + JobId: 11001 + TableName: tbl1 + CreateTime: 2020-12-23 10:41:00 + FinishTime: NULL + BaseIndexName: tbl1 +RollupIndexName: r1 + RollupId: 11002 + TransactionId: 5070 + State: WAITING_TXN + Msg: + Progress: NULL + Timeout: 86400 +1 row in set (0.00 sec) +```` + +- `JobId`: Job unique ID. + +- `TableName`: base table name + +- `CreateTime/FinishTime`: Job creation time and end time. + +- `BaseIndexName/RollupIndexName`: Base table name and materialized view name. + +- `RollupId`: The unique ID of the materialized view. + +- `TransactionId`: See the description of the State field. + +- `State`: job status. + + - PENDING: The job is in preparation. + + - WAITING_TXN: + + Before officially starting to generate materialized view data, it will wait for the current running import transaction on this table to complete. And the `TransactionId` field is the current waiting transaction ID. When all previous imports for this ID are complete, the job will actually start. + + - RUNNING: The job is running. + + - FINISHED: The job ran successfully. + + - CANCELLED: The job failed to run. + +- `Msg`: error message + +- `Progress`: job progress. The progress here means `completed tablets/total tablets`. Materialized views are created at tablet granularity. + +- `Timeout`: Job timeout, in seconds. + +### Example + +1. View the materialized view jobs under the database example_db + + ```sql + SHOW ALTER TABLE MATERIALIZED VIEW FROM example_db; + ```` + +### Keywords + + SHOW, ALTER, TABLE, MATERIALIZED, VIEW + +### Best Practice + diff --git a/docs/sql-manual/sql-reference/Show-Statements/SHOW-STATUS.md b/docs/sql-manual/sql-reference/Show-Statements/SHOW-STATUS.md index 3cdbbb51b8e..8fc40967d0a 100644 --- a/docs/sql-manual/sql-reference/Show-Statements/SHOW-STATUS.md +++ b/docs/sql-manual/sql-reference/Show-Statements/SHOW-STATUS.md @@ -1,6 +1,6 @@ --- { - "title": "SHOW ALTER TABLE MATERIALIZED VIEW", + "title": "SHOW-STATUS", "language": "en" } --- @@ -24,97 +24,19 @@ specific language governing permissions and limitations under the License. --> -## SHOW ALTER TABLE MATERIALIZED VIEW +## SHOW-STATUS ### Name -SHOW ALTER TABLE MATERIALIZED VIEW +SHOW STATUS ### Description -This command is used to view the execution of the Create Materialized View job submitted through the [CREATE-MATERIALIZED-VIEW](../../sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW) statement. - -> This statement is equivalent to `SHOW ALTER TABLE ROLLUP`; - -```sql -SHOW ALTER TABLE MATERIALIZED VIEW -[FROM database] -[WHERE] -[ORDER BY] -[LIMIT OFFSET] -```` - -- database: View jobs under the specified database. If not specified, the current database is used. -- WHERE: You can filter the result column, currently only the following columns are supported: - - TableName: Only equal value filtering is supported. - - State: Only supports equivalent filtering. - - Createtime/FinishTime: Support =, >=, <=, >, <, != -- ORDER BY: The result set can be sorted by any column. -- LIMIT: Use ORDER BY to perform page-turning query. - -Return result description: - -```sql -mysql> show alter table materialized view\G -**************************** 1. row ******************** ****** - JobId: 11001 - TableName: tbl1 - CreateTime: 2020-12-23 10:41:00 - FinishTime: NULL - BaseIndexName: tbl1 -RollupIndexName: r1 - RollupId: 11002 - TransactionId: 5070 - State: WAITING_TXN - Msg: - Progress: NULL - Timeout: 86400 -1 row in set (0.00 sec) -```` - -- `JobId`: Job unique ID. - -- `TableName`: base table name - -- `CreateTime/FinishTime`: Job creation time and end time. - -- `BaseIndexName/RollupIndexName`: Base table name and materialized view name. - -- `RollupId`: The unique ID of the materialized view. - -- `TransactionId`: See the description of the State field. - -- `State`: job status. - - - PENDING: The job is in preparation. - - - WAITING_TXN: - - Before officially starting to generate materialized view data, it will wait for the current running import transaction on this table to complete. And the `TransactionId` field is the current waiting transaction ID. When all previous imports for this ID are complete, the job will actually start. - - - RUNNING: The job is running. - - - FINISHED: The job ran successfully. - - - CANCELLED: The job failed to run. - -- `Msg`: error message - -- `Progress`: job progress. The progress here means `completed tablets/total tablets`. Materialized views are created at tablet granularity. - -- `Timeout`: Job timeout, in seconds. - ### Example -1. View the materialized view jobs under the database example_db - - ```sql - SHOW ALTER TABLE MATERIALIZED VIEW FROM example_db; - ```` - ### Keywords - SHOW, ALTER, TABLE, MATERIALIZED, VIEW + SHOW, STATUS ### Best Practice diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/logstash.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/logstash.md index bb16bc40843..9b70559ca2c 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/logstash.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ecosystem/logstash.md @@ -28,9 +28,9 @@ under the License. 该插件用于logstash输出数据到Doris,使用 HTTP 协议与 Doris FE Http接口交互,并通过 Doris 的 stream load 的方式进行数据导入. -[了解Doris Stream Load ](../data-operate/import/import-way/stream-load-manual.md) +[了解Doris Stream Load ](../data-operate/import/import-way/stream-load-manual) -[了解更多关于Doris](../) +[了解更多关于Doris](/zh-CN) ## 安装和编译 diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-ROLLUP.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-ROLLUP.md index cd72797b57b..dbb36b9969d 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-ROLLUP.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Definition-Statements/Alter/ALTER-TABLE-ROLLUP.md @@ -32,7 +32,7 @@ ALTER TABLE ROLLUP ### Description -该语句用于对已有 table 进行 rollup 进行修改操作。rollup 是异步操作,任务提交成功则返回,之后可使用[SHOW ALTER](../../Show-Statements/SHOW-ALTER.md) 命令查看进度。 +该语句用于对已有 table 进行 rollup 进行修改操作。rollup 是异步操作,任务提交成功则返回,之后可使用[SHOW ALTER](../../Show-Statements/SHOW-ALTER) 命令查看进度。 语法: diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Manipulation-Statements/Load/CREATE-SYNC-JOB.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Manipulation-Statements/Load/CREATE-SYNC-JOB.md index a4aa3d79937..d6253ec9f82 100644 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Manipulation-Statements/Load/CREATE-SYNC-JOB.md +++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Manipulation-Statements/Load/CREATE-SYNC-JOB.md @@ -36,7 +36,7 @@ CREATE SYNC JOB 目前数据同步作业只支持对接Canal,从Canal Server上获取解析好的Binlog数据,导入到Doris内。 -用户可通过 [SHOW SYNC JOB](../../Show-Statements/SHOW-SYNC-JOB.md) 查看数据同步作业状态。 +用户可通过 [SHOW SYNC JOB](../../Show-Statements/SHOW-SYNC-JOB) 查看数据同步作业状态。 语法: --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org