SHOW TABLET STORAGE FORMAT

Description

This statement is used to display storage format information on the Backend.

Syntax

SHOW TABLET STORAGE FORMAT [VERBOSE]

Optional Parameters

** 1. VERBOSE **

Displays more detailed information.

Return Value

Default output (without VERBOSE):

Column	DataType	Note
BackendId	Int	The ID of the BE (Backend) node where the tablet replica is located.
V1Count	Int	Number of V1 version tablets.
V2Count	Int	Number of V2 version tablets.

With VERBOSE:

Column	DataType	Note
BackendId	Int	The ID of the BE (Backend) node where the tablet replica is located.
TabletId	Int	The unique identifier of the tablet.
StorageFormat	String	The version of the tablet, either V1 or V2.

Access Control Requirements

The user executing this SQL command must have at least the following privileges:

Privilege	Object	Notes
Admin_priv	Database	Required to execute administrative operations on the database, including managing tables, partitions, and system-level commands.

Examples

• Execute the statement without the verbose parameter

  show tablet storage format;

  +-----------+---------+---------+
  | BackendId | V1Count | V2Count |
  +-----------+---------+---------+
  | 10002     | 0       | 2867    |
  +-----------+---------+---------+

• Execute the statement with the verbose parameter

  show tablet storage format verbose;

  +-----------+----------+---------------+
  | BackendId | TabletId | StorageFormat |
  +-----------+----------+---------------+
  | 10002     | 39227    | V2            |
  | 10002     | 39221    | V2            |
  | 10002     | 39215    | V2            |
  | 10002     | 39199    | V2            |
  +-----------+----------+---------------+