EmmyMiao87 opened a new pull request #3209: Add 'IndexKeysType' field in 'Desc all table stmt' URL: https://github.com/apache/incubator-doris/pull/3209 After doris support aggregation materialized view on duplicate table, desc stmt of metadata is confused in sometimes. The reason is that there is no grouping information in desc stmt of metadata. For example: There are two materialized view as following. 1. create materialized view k1_k2 as select k1, k2 from table; 2. create materialzied view deduplicated_k1_k2 as select k1, k2 from table group by k1, k2; Before this commit, the metatdata in desc stmt is the same. +-----------------------+-------+----------+------+-------+---------+-------+ | IndexName | Field | Type | Null | Key | Default | Extra | +-----------------------+-------+----------+------+-------+---------+-------+ | k1_k2 | k1 | TINYINT | Yes | true | N/A | | | | k2 | SMALLINT | Yes | true | N/A | | | deduplicated_k1_k2 | k1 | TINYINT | Yes | true | N/A | | | | k2 | SMALLINT | Yes | true | N/A | | +-----------------------+-------+----------+------+-------+---------+-------+ So, we need to show the KeysType of materialized view in desc stmt. Now, the desc stmt of all mvs is changed as following: +-----------------------+---------------+-------+----------+------+-------+---------+-------+ | IndexName | IndexKeysType | Field | Type | Null | Key | Default | Extra | +-----------------------+---------------+-------+----------+------+-------+---------+-------+ | k1_k2 | DUP_KEYS | k1 | TINYINT | Yes | true | N/A | | | | | k2 | SMALLINT | Yes | true | N/A | | | deduplicated_k1_k2 | AGG_KEYS | k1 | TINYINT | Yes | true | N/A | | | | | k2 | SMALLINT | Yes | true | N/A | | +-----------------------+---------------+-------+----------+------+-------+---------+-------+
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
