wyxxxcat opened a new pull request, #42338:
URL: https://github.com/apache/doris/pull/42338
## 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
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 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: [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]
