system.distribution_queue

Contains information about local files that are in the queue to be sent to the shards. These local files contain new parts that are created by inserting new data into the Distributed table in asynchronous mode.

Columns:

  • database (String) — Name of the database.

  • table (String) — Name of the table.

  • data_path (String) — Path to the folder with local files.

  • is_blocked (UInt8) — Flag indicates whether sending local files to the server is blocked.

  • error_count (UInt64) — Number of errors.

  • data_files (UInt64) — Number of local files in a folder.

  • data_compressed_bytes (UInt64) — Size of compressed data in local files, in bytes.

  • broken_data_files (UInt64) — Number of files that has been marked as broken (due to an error).

  • broken_data_compressed_bytes (UInt64) — Size of compressed data in broken files, in bytes.

  • last_exception (String) — Text message about the last error that occurred (if any).

Example

  1. SELECT * FROM system.distribution_queue LIMIT 1 FORMAT Vertical;
  1. Row 1:
  2. ──────
  3. database: default
  4. table: dist
  5. data_path: ./store/268/268bc070-3aad-4b1a-9cf2-4987580161af/[email protected]%2E0%2E0%2E2:9000/
  6. is_blocked: 1
  7. error_count: 0
  8. data_files: 1
  9. data_compressed_bytes: 499
  10. last_exception:

See Also