wyxxxcat opened a new pull request, #42367:
URL: https://github.com/apache/doris/pull/42367
## Proposed changes
Issue Number: close #32154
<!--Describe your changes.-->
```
mysql> CREATE TABLE user_info
-> (
-> id INT,
-> name VARCHAR(50),
-> age INT
-> )
-> DISTRIBUTED BY HASH(id) BUCKETS 10
-> PROPERTIES (
-> "replication_allocation" = "tag.location.default: 1",
-> "storage_vault_name" = "s3_vault"
-> );
mysql> select * from user_info;
+------+---------+------+
| id | name | age |
+------+---------+------+
| 1 | Alice | 25 |
| 4 | John | 29 |
| 3 | Charlie | 35 |
| 2 | Bob | 30 |
| 5 | Mars | 17 |
+------+---------+------+
5 rows in set (0.03 sec)
mysql> select * from information_schema.rowsets;
+------------+--------------------------------------------------+-----------+-----------------+----------------+--------------+---------------+-------------+-----------------+----------------+---------------------+------------------------+----------------+
| BACKEND_ID | ROWSET_ID | TABLET_ID
| ROWSET_NUM_ROWS | TXN_ID | NUM_SEGMENTS | START_VERSION | END_VERSION
| INDEX_DISK_SIZE | DATA_DISK_SIZE | CREATION_TIME |
NEWEST_WRITE_TIMESTAMP | SCHEMA_VERSION |
+------------+--------------------------------------------------+-----------+-----------------+----------------+--------------+---------------+-------------+-----------------+----------------+---------------------+------------------------+----------------+
| 10113 | 020000000000000a09486762915a15fb053086a6548817b5 | 27246
| 0 | 67553868076032 | 0 | 2 | 2
| 0 | 0 | 2024-10-23 18:18:22 | 2024-10-23 18:18:22
| 0 |
| 10113 | 0200000000000000ffffffffffffffeefffffffffc933148 | 27246
| 0 | 0 | 0 | 0 | 1
| 0 | 0 | 1970-01-01 08:00:00 | 1970-01-01 07:59:59
| 0 |
| 10113 | 020000000000000909486762915a15fb053086a6548817b5 | 27242
| 1 | 67553868076032 | 1 | 2 | 2
| 151 | 622 | 2024-10-23 18:18:22 | 2024-10-23 18:18:22
| 0 |
| 10113 | 0200000000000000ffffffffffffffedffffffffffffffed | 27242
| 0 | 0 | 0 | 0 | 1
| 0 | 0 | 1970-01-01 08:00:00 | 1970-01-01 07:59:59
| 0 |
| 10113 | 020000000000000809486762915a15fb053086a6548817b5 | 27232
| 0 | 67553868076032 | 0 | 2 | 2
| 0 | 0 | 2024-10-23 18:18:22 | 2024-10-23 18:18:22
| 0 |
| 10113 | 0200000000000000ffffffffffffffc4fffffffffef25131 | 27232
| 0 | 0 | 0 | 0 | 1
| 0 | 0 | 1970-01-01 08:00:00 | 1970-01-01 07:59:59
| 0 |
| 10113 | 020000000000000609486762915a15fb053086a6548817b5 | 27244
| 1 | 67553868076032 | 1 | 2 | 2
| 155 | 639 | 2024-10-23 18:18:22 | 2024-10-23 18:18:22
| 0 |
| 10113 | 0200000000000000fffffffffffffea6fffffffffffffb83 | 27244
| 0 | 0 | 0 | 0 | 1
| 0 | 0 | 1970-01-01 08:00:00 | 1970-01-01 07:59:59
| 0 |
| 10113 | 020000000000000709486762915a15fb053086a6548817b5 | 27250
| 1 | 67553868076032 | 1 | 2 | 2
| 152 | 627 | 2024-10-23 18:18:22 | 2024-10-23 18:18:22
| 0 |
| 10113 | 0200000000000000fffffffffffffffdfffffffffffffef2 | 27250
| 0 | 0 | 0 | 0 | 1
| 0 | 0 | 1970-01-01 08:00:00 | 1970-01-01 07:59:59
| 0 |
| 10113 | 020000000000000509486762915a15fb053086a6548817b5 | 27236
| 0 | 67553868076032 | 0 | 2 | 2
| 0 | 0 | 2024-10-23 18:18:22 | 2024-10-23 18:18:22
| 0 |
| 10113 | 0200000000000000ffffffffffffee14ffffffffd5536744 | 27236
| 0 | 0 | 0 | 0 | 1
| 0 | 0 | 1970-01-01 08:00:00 | 1970-01-01 07:59:59
| 0 |
| 10113 | 020000000000000409486762915a15fb053086a6548817b5 | 27240
| 1 | 67553868076032 | 1 | 2 | 2
| 152 | 628 | 2024-10-23 18:18:22 | 2024-10-23 18:18:22
| 0 |
| 10113 | 0200000000000000fffffffffffffec2ffffffffffffffe7 | 27240
| 0 | 0 | 0 | 0 | 1
| 0 | 0 | 1970-01-01 08:00:00 | 1970-01-01 07:59:59
| 0 |
| 10113 | 020000000000000209486762915a15fb053086a6548817b5 | 27238
| 0 | 67553868076032 | 0 | 2 | 2
| 0 | 0 | 2024-10-23 18:18:22 | 2024-10-23 18:18:22
| 0 |
| 10113 | 0200000000000000ffffffffffffef46ffffffffffffffd6 | 27238
| 0 | 0 | 0 | 0 | 1
| 0 | 0 | 1970-01-01 08:00:00 | 1970-01-01 07:59:59
| 0 |
| 10113 | 020000000000000309486762915a15fb053086a6548817b5 | 27234
| 1 | 67553868076032 | 1 | 2 | 2
| 153 | 629 | 2024-10-23 18:18:22 | 2024-10-23 18:18:22
| 0 |
| 10113 | 0200000000000000ffffffffffffec02ffffffffffffa941 | 27234
| 0 | 0 | 0 | 0 | 1
| 0 | 0 | 1970-01-01 08:00:00 | 1970-01-01 07:59:59
| 0 |
| 10113 | 020000000000000109486762915a15fb053086a6548817b5 | 27248
| 0 | 67553868076032 | 0 | 2 | 2
| 0 | 0 | 2024-10-23 18:18:22 | 2024-10-23 18:18:22
| 0 |
| 10113 | 0200000000000000fffffffffffffffeffffffffffff9767 | 27248
| 0 | 0 | 0 | 0 | 1
| 0 | 0 | 1970-01-01 08:00:00 | 1970-01-01 07:59:59
| 0 |
+------------+--------------------------------------------------+-----------+-----------------+----------------+--------------+---------------+-------------+-----------------+----------------+---------------------+------------------------+----------------+
mysql> show tablet 22140\G;
*************************** 1. row ***************************
DbName: wyx
TableName: user_info
PartitionName: user_info
IndexName: user_info
DbId: 22052
TableId: 22112
PartitionId: 22111
IndexId: 22113
IsSync: true
Order: 3
QueryHits: 0
DetailCmd: SHOW PROC '/dbs/27151/27210/partitions/27209/27211/27246';
1 row in set (0.00 sec)
mysql> SHOW PROC '/dbs/27151/27210/partitions/27209/27211/27246'\G;
*************************** 1. row ***************************
ReplicaId: 27247
BackendId: 10113
Version: 1
LstSuccessVersion: 1
LstFailedVersion: -1
LstFailedTime: NULL
SchemaHash: 1699744685
LocalDataSize: 0
RemoteDataSize: 0
RowCount: 0
State: NORMAL
IsBad: false
IsUserDrop: false
VisibleVersionCount: -1
VersionCount: -1
PathHash: -1
Path:
MetaUrl: http://192.168.31.122:8440/api/meta/header/27246
CompactionStatus:
http://192.168.31.122:8440/api/compaction/show?tablet_id=27246
CooldownReplicaId: -1
CooldownMetaId:
QueryHits: 0
PrimaryBackendId: 10113
1 row in set (0.00 sec)
```
--
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: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
