tencent cloud

TDSQL Boundless

DocumentationTDSQL Boundless

TDSTORE_COLUMNAR_NODE_DATA_COUNT_INFO

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

Function

INFORMATION_SCHEMA.TDSTORE_COLUMNAR_NODE_DATA_COUNT_INFO is used to count the amount of data in row storage and data in columnar storage in a table, and the ratio between them.

Field Description

Field Name
Type
Description
node_name
VARCHAR
The node where the table being counted resides.
db_name
VARCHAR
The database name where the table being counted resides.
table_name
VARCHAR
The name of the table being counted.
table_id
INT
The id of the table being counted.
column_data_count
INT
The number of rows of columnar storage data in the table being counted.
row_data_count
INT
The number of rows of row storage data in the table being counted.
data_ratio
DOUBLE
The ratio of rows of columnar storage data to rows of row storage data in the table being counted (rows of columnar storage data / rows of row storage data).

Examples

tdsql3_sys_local@localhost [information_schema]> select * from TDSTORE_COLUMNAR_NODE_DATA_COUNT_INFO\\G
*************************** 1. row ***************************
        node_name: node-run-test_reboot-001
          db_name: test_base
       table_name: test_table
         table_id: 10026
column_data_count: 4
   row_data_count: 2702
       data_ratio: 0.0014803849000740192
1 row in set (0.00 sec)
Next Topic: Release Notes

Help and Support

Was this page helpful?

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

Feedback