Yang, Tong 3f5759eed2 MRS comp-lts 2.0.38.SP20 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>

2023-01-19 17:08:45 +00:00

5.8 KiB

Raw Permalink Blame History

SHOW SEGMENTS

Function

This command is used to list the segments of a CarbonData table.

Syntax

SHOW SEGMENTS FOR TABLE [db_name.]table_name LIMIT number_of_loads;

Parameter Description

**Table 1** SHOW SEGMENTS FOR TABLE parameters
Parameter	Description
db_name	Database name. If this parameter is not specified, the current database is used.
table_name	Name of a table in the specified database
number_of_loads	Threshold of records to be listed

Precautions

None

Examples

SHOW SEGMENTS FOR TABLE CarbonDatabase.CarbonTable LIMIT 2;

System Response

+-----+----------+--------------------------+------------------+------------+------------+-------------+--------------+--+
| ID  |  Status  |     Load Start Time      | Load Time Taken  | Partition  | Data Size  | Index Size  | File Format  |
+-----+----------+--------------------------+------------------+------------+------------+-------------+--------------+--+
| 3   | Success  | 2020-09-28 22:53:26.336  | 3.726S           | {}         | 6.47KB     | 3.30KB      | columnar_v3  |
| 2   | Success  | 2020-09-28 22:53:01.702  | 6.688S           | {}         | 6.47KB     | 3.30KB      | columnar_v3  |
+-----+----------+--------------------------+------------------+------------+------------+-------------+--------------+--+

Parent topic: DML

5.8 KiB Raw Permalink Blame History