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]

Reply via email to