getComputeGroupChunksStatus

Syntax

getComputeGroupChunksStatus([computeGroup])

Arguments

computeGroup (optional) is a string indicating the compute group.

Details

This function obtains the metadata about all database chunks (file chunks and tablet chunks) on the compute nodes. It must be executed on a controller.

Return value: A table containing the following columns:

  • chunkId: Chunk ID.
  • file: Chunk path.
  • routedTo: Compute node to which queries are routed.
  • cachedOn: Compute node on which the chunk is cached, in the format alias:[version]. For example, orca2:[29] means the compute node orca2 caches chunk data of version 29.
  • computeGroup: Compute group(s) where the chunk is cached.
  • size: Disk space occupied by the file chunk (in Bytes). Return 0 for a tablet chunk. Use getTabletsMeta to check the disk usage of a tablet chunk.
  • version: Version number of the current chunk.
  • vcLength: Length of the version chain.
  • versionChain: Version chain of the chunk, e.g. "18441:76:1:346 -> 18441:0:0:346 -> ".
  • state: Chunk state. It can be
    • CONSTRUCTING: in transaction.
    • RECOVERING: recovering.
    • COMPLETE: transaction completed.
  • dataNodeReplicas: Replica information of the chunk on data nodes.
  • dataNodeReplicaCount: Number of replica(s) on data nodes.
  • lastUpdated: Last modification timestamp.
  • permission: Chunk permission. It can be READ_WRITE (default) and READ_ONLY. Chunks that are being transferred or stored in S3 are READ_ONLY.

Examples

getComputeGroupChunksStatus()
chunkId path routedTo cachedOn computeGroup size version vcLength versionChain state dataNodeReplicas dataNodeReplicaCount lastUpdated permission
0 abec288a-49f7-61b9-464e-56bf134c8340 /Storage_compute_separation_tsdb/20120110/Key19/2 orca3 [NOT CACHED] orca 0 1 1 1466:0:1:1466 -> COMPLETE dnode2:1:0:false:0 1 2024.10.12 17:26:51.757 READ_WRITE
1 fdb95a8e-72f0-21a7-0443-2cbe02feeca2 /Storage_compute_separation_tsdb/20120229/Key1/2 orca1 [NOT CACHED] orca 0 1 1 1463:0:1:1463 -> COMPLETE dnode3:1:0:false:0 1 2024.10.12 17:26:51.708 READ_WRITE
2 55020019-8b2c-75a1-3b40-7ad2469abe48 /Storage_compute_separation_tsdb/20120110/Key13/2 orca3 [NOT CACHED] orca 0 1 1 1458:0:1:1458 -> COMPLETE dnode3:1:0:false:0 1 2024.10.12 17:26:51.618 READ_WRITE
3 96678f5f-6ae5-2b98-9944-5d4370473dee /Storage_compute_separation_tsdb/20120110/Key7/2 orca2 [NOT CACHED] orca 0 1 1 1456:0:1:1456 -> COMPLETE dnode1:1:0:false:0 1 2024.10.12 17:26:51.583 READ_WRITE