morrySnow commented on code in PR #2003: URL: https://github.com/apache/doris-website/pull/2003#discussion_r1952251537
########## docs/sql-manual/sql-statements/table-and-view/materialized-view/SHOW-ALTER-TABLE-MATERIALIZED-VIEW.md: ########## @@ -24,92 +24,84 @@ specific language governing permissions and limitations under the License. --> - ## Description -This command is used to view the execution of the Create Materialized View job submitted through the [CREATE-MATERIALIZED-VIEW](../../table-and-view/materialized-view/CREATE-MATERIALIZED-VIEW.md) statement. +This command is used to check the execution status of the materialized view creation job submitted via statement [CREATE-MATERIALIZED-VIEW](../../../sql-statements/table-and-view/materialized-view/CREATE-MATERIALIZED-VIEW.md) > This statement is equivalent to `SHOW ALTER TABLE ROLLUP`; +## Syntax + ```sql SHOW ALTER TABLE MATERIALIZED VIEW -[FROM database] -[WHERE] -[ORDER BY] -[LIMIT OFFSET] +[FROM <database>] +[<where_clause>] +[ORDER BY <order_by_key> [, ...]] +[LIMIT <limit_rows> [ OFFSET <offset_rows>] ``` -- 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. +## Optional Parameters -Return result description: +**1. `FROM <database>`** -```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) -``` +> View jobs under the specified database. If not specified, the current database will be used. -- `JobId`: Job unique ID. +**2. `where_clause`** Review Comment: ```suggestion **2. `<where_clause>`** ``` ########## docs/sql-manual/sql-statements/table-and-view/materialized-view/SHOW-ALTER-TABLE-MATERIALIZED-VIEW.md: ########## @@ -24,92 +24,84 @@ specific language governing permissions and limitations under the License. --> - ## Description -This command is used to view the execution of the Create Materialized View job submitted through the [CREATE-MATERIALIZED-VIEW](../../table-and-view/materialized-view/CREATE-MATERIALIZED-VIEW.md) statement. +This command is used to check the execution status of the materialized view creation job submitted via statement [CREATE-MATERIALIZED-VIEW](../../../sql-statements/table-and-view/materialized-view/CREATE-MATERIALIZED-VIEW.md) > This statement is equivalent to `SHOW ALTER TABLE ROLLUP`; +## Syntax + ```sql SHOW ALTER TABLE MATERIALIZED VIEW -[FROM database] -[WHERE] -[ORDER BY] -[LIMIT OFFSET] +[FROM <database>] +[<where_clause>] +[ORDER BY <order_by_key> [, ...]] +[LIMIT <limit_rows> [ OFFSET <offset_rows>] ``` -- 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. +## Optional Parameters -Return result description: +**1. `FROM <database>`** -```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) -``` +> View jobs under the specified database. If not specified, the current database will be used. -- `JobId`: Job unique ID. +**2. `where_clause`** -- `TableName`: base table name +> You can filter the result columns, and currently, only the following columns are supported for filtering: +- TableName: Only supports equality filtering. +- State: Only supports equality filtering. +- Createtime/FinishTime: Supports =, >=, <=, >, <, !=. -- `CreateTime/FinishTime`: Job creation time and end time. +**3. `ORDER BY`** -- `BaseIndexName/RollupIndexName`: Base table name and materialized view name. +> You can sort the result set by any column. -- `RollupId`: The unique ID of the materialized view. +**4. `LIMIT`** Review Comment: ```suggestion **4. `LIMIT <limit_rows> [ OFFSET <offset_rows>]`** ``` ########## docs/sql-manual/sql-statements/table-and-view/materialized-view/SHOW-ALTER-TABLE-MATERIALIZED-VIEW.md: ########## @@ -24,92 +24,84 @@ specific language governing permissions and limitations under the License. --> - ## Description -This command is used to view the execution of the Create Materialized View job submitted through the [CREATE-MATERIALIZED-VIEW](../../table-and-view/materialized-view/CREATE-MATERIALIZED-VIEW.md) statement. +This command is used to check the execution status of the materialized view creation job submitted via statement [CREATE-MATERIALIZED-VIEW](../../../sql-statements/table-and-view/materialized-view/CREATE-MATERIALIZED-VIEW.md) > This statement is equivalent to `SHOW ALTER TABLE ROLLUP`; +## Syntax + ```sql SHOW ALTER TABLE MATERIALIZED VIEW -[FROM database] -[WHERE] -[ORDER BY] -[LIMIT OFFSET] +[FROM <database>] +[<where_clause>] +[ORDER BY <order_by_key> [, ...]] +[LIMIT <limit_rows> [ OFFSET <offset_rows>] Review Comment: ```suggestion [LIMIT <limit_rows> [ OFFSET <offset_rows>]] ``` ########## docs/sql-manual/sql-statements/table-and-view/materialized-view/SHOW-ALTER-TABLE-MATERIALIZED-VIEW.md: ########## @@ -24,92 +24,84 @@ specific language governing permissions and limitations under the License. --> - ## Description -This command is used to view the execution of the Create Materialized View job submitted through the [CREATE-MATERIALIZED-VIEW](../../table-and-view/materialized-view/CREATE-MATERIALIZED-VIEW.md) statement. +This command is used to check the execution status of the materialized view creation job submitted via statement [CREATE-MATERIALIZED-VIEW](../../../sql-statements/table-and-view/materialized-view/CREATE-MATERIALIZED-VIEW.md) > This statement is equivalent to `SHOW ALTER TABLE ROLLUP`; +## Syntax + ```sql SHOW ALTER TABLE MATERIALIZED VIEW -[FROM database] -[WHERE] -[ORDER BY] -[LIMIT OFFSET] +[FROM <database>] +[<where_clause>] +[ORDER BY <order_by_key> [, ...]] +[LIMIT <limit_rows> [ OFFSET <offset_rows>] ``` -- 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. +## Optional Parameters -Return result description: +**1. `FROM <database>`** -```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) -``` +> View jobs under the specified database. If not specified, the current database will be used. -- `JobId`: Job unique ID. +**2. `where_clause`** -- `TableName`: base table name +> You can filter the result columns, and currently, only the following columns are supported for filtering: +- TableName: Only supports equality filtering. +- State: Only supports equality filtering. +- Createtime/FinishTime: Supports =, >=, <=, >, <, !=. -- `CreateTime/FinishTime`: Job creation time and end time. +**3. `ORDER BY`** -- `BaseIndexName/RollupIndexName`: Base table name and materialized view name. +> You can sort the result set by any column. -- `RollupId`: The unique ID of the materialized view. +**4. `LIMIT`** -- `TransactionId`: See the description of the State field. +> Use ORDER BY for pagination queries. Review Comment: 这里是不是写错了，应该是limit相关的解释 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
