# 查看数据库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" # 副本集数，也就是每个桶有几个副本。
);