Help wanted!

The following content of this documentation page has been machine-translated. But unlike other websites, it is not done on the fly. This translated text lives on GitHub repository alongside main ClickHouse codebase and waits for fellow native speakers to make it more human-readable. You can also use the original English version as a reference.

Help ClickHouse documentation by editing this page

系统。part_log

该 system.part_log 表只有当创建 part_log 指定了服务器设置。

此表包含与以下情况发生的事件有关的信息 数据部分 在 MergeTree 家庭表，例如添加或合并数据。

该 system.part_log 表包含以下列:

• event_type (Enum) — Type of the event that occurred with the data part. Can have one of the following values:
  • NEW_PART — Inserting of a new data part.
  • MERGE_PARTS — Merging of data parts.
  • DOWNLOAD_PART — Downloading a data part.
  • REMOVE_PART — Removing or detaching a data part using DETACH PARTITION.
  • MUTATE_PART — Mutating of a data part.
  • MOVE_PART — Moving the data part from the one disk to another one.
• event_date (Date) — Event date.
• event_time (DateTime) — Event time.
• duration_ms (UInt64) — Duration.
• database (String) — Name of the database the data part is in.
• table (String) — Name of the table the data part is in.
• part_name (String) — Name of the data part.
• partition_id (String) — ID of the partition that the data part was inserted to. The column takes the ‘all’ 值，如果分区是由 tuple().
• rows (UInt64) — The number of rows in the data part.
• size_in_bytes (UInt64) — Size of the data part in bytes.
• merged_from (Array(String)) — An array of names of the parts which the current part was made up from (after the merge).
• bytes_uncompressed (UInt64) — Size of uncompressed bytes.
• read_rows (UInt64) — The number of rows was read during the merge.
• read_bytes (UInt64) — The number of bytes was read during the merge.
• error (UInt16) — The code number of the occurred error.
• exception (String) — Text message of the occurred error.

该 system.part_log 表的第一个插入数据到后创建 MergeTree 桌子