Note
This view is available starting with V4.0.0.
Purpose
This view displays the tablet list of the current tenant and the log stream information to which each tablet belongs.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| TABLET_ID | bigint(20) | NO | The tablet ID. |
| LS_ID | bigint(1) | NO | The log stream ID to which the tablet belongs. |
Sample query
Query the tablet list of log stream 1001 in the current tenant and display the first five rows.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_TABLET_TO_LS WHERE LS_ID=1001 LIMIT 5;
The query result is as follows:
+-----------+-------+
| TABLET_ID | LS_ID |
+-----------+-------+
| 200004 | 1001 |
| 200005 | 1001 |
| 200007 | 1001 |
| 200008 | 1001 |
| 200009 | 1001 |
+-----------+-------+
5 rows in set