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