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¶
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 |
+-----+----------+--------------------------+------------------+------------+------------+-------------+--------------+--+