tencent cloud

TDSQL Boundless

DocumentationTDSQL Boundless

TDSTORE_COLUMNAR_FILES_INFO

Focus Mode
Font Size
Last updated: 2026-02-10 11:06:31

Function

INFORMATION_SCHEMA.TDSTORE_COLUMNAR_FILES_INFO displays information about columnar files in columnar nodes.

Field Description

Field Name
Type
Description
TABLE_ID
INT
The TIndexID of the table corresponding to the file.
DB
VARCHAR
The name of the DATABASE corresponding to the file.
TABLE_NAME
VARCHAR
The name of the TABLE corresponding to the file.
FILE_PATH
VARCHAR
The absolute path of the file.
FILE_ID
INT
The ID of the file.
FILE_SIZE_IN_MB
DOUBLE
The size of the file, in MB.
LAST_WRITE_TIME
VARCHAR
The last modified time of the file.
RECORD_COUNT
INT
The total number of data rows in the file.
INVALID_RECORD_COUNT
INT
The number of invalid data rows in the file.
INVALID_RATIO
DOUBLE
The proportion of invalid data in the file, that is INVALID_RECORD_COUNT/RECORD_COUNT.

Examples

SELECT * FROM TDSTORE_COLUMNAR_FILES_INFO;
+----------+----------+------------+-----------------------------------------------------------------------------------------------------------+---------+-------------------+---------------------+--------------+----------------------+---------------+
| TABLE_ID | DB       | TABLE_NAME | FILE_PATH                                                                                                 | FILE_ID | FILE_SIZE_IN_MB   | LAST_WRITE_TIME     | RECORD_COUNT | INVALID_RECORD_COUNT | INVALID_RATIO |
+----------+----------+------------+-----------------------------------------------------------------------------------------------------------+---------+-------------------+---------------------+--------------+----------------------+---------------+
|    10024 | tpch100g | part       | /data/tdsql/auto-install-clang-debug-build/10351/data/10351/tdstore/columnar_data/10024_00000010.parquet |      10 | 25.18278980255127 | 2025-04-16 16:19:25 |       500387 |                    0 |             0 |
|    10024 | tpch100g | part       | /data/tdsql/auto-install-clang-debug-build/10351/data/10351/tdstore/columnar_data/10024_00000012.parquet |      12 | 25.41611957550049 | 2025-04-16 16:19:32 |       502697 |                    0 |             0 |
+----------+----------+------------+-----------------------------------------------------------------------------------------------------------+---------+-------------------+---------------------+--------------+----------------------+---------------+

Next Topic: Release Notes

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback