# 查看数据库id对应的数据库名 mysql> show database 11237; # 查看表id对应的表名 mysql> show table 239829; # 查看表有哪些分区 mysql> show partitions from base_transfer\G; # 过滤 mysql> show partitions from base_transfer where `partitionid` = 239780; # 值不能加引号,要不查不出来 # 查看建表语句 mysql> show create table base_transfer\G; # 查看副本状态 mysql> ADMIN SHOW REPLICA STATUS FROM base_transfer; +----------+-----------+-----------+---------+-------------------+--------------------+------------------+------------+------------+-------+--------+--------+ | TabletId | ReplicaId | BackendId | Version | LastFailedVersion | LastSuccessVersion | CommittedVersion | SchemaHash | VersionNum | IsBad | State | Status | +----------+-----------+-----------+---------+-------------------+--------------------+------------------+------------+------------+-------+--------+--------+ | 270021 | 270022 | 11126 | 1 | -1 | 1 | 1 | 564419587 | 1 | false | NORMAL | OK | | 270023 | 270024 | 11180 | 1 | -1 | 1 | 1 | 564419587 | 1 | false | NORMAL | OK | | 270025 | 270026 | 11181 | 1 | -1 | 1 | 1 | 564419587 | 1 | false | NORMAL | OK | # 过滤 mysql> ADMIN SHOW REPLICA STATUS FROM base_transfer where status != 'OK'; 更多状态参考:https://doris.apache.org/zh-CN/docs/2.0/sql-manual/sql-reference/Database-Administration-Statements/ADMIN-SHOW-REPLICA-STATUS # 查看分片 mysql> show tablet 270891; 表table -> 分区partition -> 分片(桶)tablet # 数据库id 表id从web中查看/System?path=/dbs/11237,或者通过 show proc "/"; 查看 SHOW PROC '/dbs/11237/1563242/partitions/1563239/1563243'; 更多show proc用法参考:https://doris.apache.org/zh-CN/docs/2.0/sql-manual/sql-reference/Show-Statements/SHOW-PROC # 建表 CREATE TABLE `base_test111111` ( `block_number` largeint(40) NULL, `block_time` datetime NULL, `trans_hash` varchar(120) NULL, `log_index` int(11) NULL, `from_address` varchar(120) NULL, `to_address` varchar(120) NULL, `quantity` varchar(120) NULL, `amount_usd` varchar(120) NULL, `token_id` varchar(120) NULL, `token_address` varchar(120) NULL, `wallet_from` varchar(120) NULL, `wallet_to` varchar(120) NULL, `_id` varchar(120) NOT NULL, INDEX block_number_index (`block_number`) USING BITMAP COMMENT '区块号', INDEX block_time_index (`block_time`) USING BITMAP COMMENT '区块时间' ) ENGINE=OLAP UNIQUE KEY(`block_number`, `block_time`, `trans_hash`, `log_index`) COMMENT 'base_transfer交易表' PARTITION BY RANGE(`block_time`) ( PARTITION month_202401 VALUES [('2024-01-01 00:00:00'), ('2024-02-01 00:00:00')), PARTITION month_202402 VALUES [('2024-02-01 00:00:00'), ('2024-03-01 00:00:00')), PARTITION month_202403 VALUES [('2024-03-01 00:00:00'), ('2024-04-01 00:00:00')), PARTITION month_202404 VALUES [('2024-04-01 00:00:00'), ('2024-05-01 00:00:00')), PARTITION month_202405 VALUES [('2024-05-01 00:00:00'), ('2024-06-01 00:00:00')) ) DISTRIBUTED BY HASH(`trans_hash`) BUCKETS 10 # 设置桶的数量,1.2.2版本之后可以设置为自动 BUCKETS AUTO PROPERTIES ( "replication_num" = "3" # 副本集数,也就是每个桶有几个副本。 );
原创文章,转载请注明。本文链接地址: https://www.rootop.org/pages/5414.html