tencent cloud

TDSQL Boundless

DocumentationTDSQL Boundless

TDSTORE_COLUMNAR_COMPACTION_INFO

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

Function

INFORMATION_SCHEMA.TDSTORE_COLUMNAR_COMPACTION_INFO is used to record the execution process and results of columnar compaction and drop table tasks.

Field Description

Field Name
Type
Description
node_name
VARCHAR
The node name that executes the columnar compaction.
job_description
VARCHAR
Description of the columnar compaction task:
Regular compaction
drop table
event_type
VARCHAR
type of the columnar compaction task (TD_EVENT_COLUMNAR_COMPACT).
table_name
VARCHAR
The table name on which columnar compaction is performed.
tx_id
INT
The transaction ID of the columnar transaction on which columnar compaction is performed.
tx_seq_num
INT
The sequence number corresponding to the oldest snapshot of the columnar metadata database obtained after the columnar transaction for columnar compaction is committed.
ret
VARCHAR
Return code of the task for columnar compaction.
compacted_files
VARCHAR
Reclaimed file list of the columnar compaction task.
new_files
VARCHAR
File list generated by the columnar compaction task.
begin_time
VARCHAR
Start time of the columnar compaction task.
cost_us
INT
Total time taken by the columnar compaction task.
detailed_info
VARCHAR
Time taken for each step in the columnar compaction task.

Examples

tdsql3_sys_local@localhost [test_base]> SELECT * FROM information_schema.TDSTORE_COLUMNAR_COMPACTION_INFO\\G
*************************** 1. row ***************************
      node_name: node-run-test_reboot-001
job_description: columnar compaction
     event_type: TD_EVENT_COLUMNAR_COMPACT
     table_name: test_table
          tx_id: 12
     tx_seq_num: 13
            ret: 0(EC_OK)
compacted_files: 10026_2, 10026_1
      new_files: 3
     begin_time: 2025-04-22 18:51:49 215
        cost_us: 4910
  detailed_info:  [COLUMNAR_FILE_DEFRAGMENTATION: <BEGIN: 4695us>, <REWRITE_FILES: 85us>, <META_MODIFICATION: 123us>, <REMOVE_PKS: 0us>, <COMMIT: 6us>] 
*************************** 2. row ***************************
      node_name: node-run-test_reboot-001
job_description: columnar compaction
     event_type: TD_EVENT_COLUMNAR_COMPACT
     table_name: test_table
          tx_id: 22
     tx_seq_num: 28
            ret: 0(EC_OK)
compacted_files: 10026_3, 10026_5, 10026_4
      new_files: 6
     begin_time: 2025-04-22 18:52:19 235
        cost_us: 6800
  detailed_info:  [COLUMNAR_FILE_DEFRAGMENTATION: <BEGIN: 6563us>, <REWRITE_FILES: 86us>, <META_MODIFICATION: 141us>, <REMOVE_PKS: 0us>, <COMMIT: 7us>] 
2 rows in set (0.01 sec)
Next Topic: Release Notes

Help and Support

Was this page helpful?

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

Feedback