graphite.tagged

CREATE TABLE graphite.tagged
(
    `Date` Date,
    `Name` String CODEC(ZSTD(1)),
    `Path` String CODEC(ZSTD(1)),
    `Tags` Array(String),
    `Version` UInt32,
    `Host` LowCardinality(String) CODEC(ZSTD(1)),
    `Hostname` LowCardinality(String) CODEC(ZSTD(1)),
    `Namespace` LowCardinality(String) CODEC(ZSTD(1)),
    `Aggregate` LowCardinality(String) CODEC(ZSTD(1)),
    `Port` LowCardinality(String) CODEC(ZSTD(1)),
    `Cluster` LowCardinality(String) CODEC(ZSTD(1)),
    `Env` LowCardinality(String) CODEC(ZSTD(1)),
    `ClusterEnv` LowCardinality(String) CODEC(ZSTD(1)),
    `App` LowCardinality(String) CODEC(ZSTD(1)),
    `Application` LowCardinality(String) CODEC(ZSTD(1)),
    `Ver` String CODEC(ZSTD(1)),
    `Pod` String CODEC(ZSTD(1)),
    `PodName` String CODEC(ZSTD(1)),
    `Container` String CODEC(ZSTD(1)),
    `ContainerName` String CODEC(ZSTD(1)),
    `DatName` LowCardinality(String) CODEC(ZSTD(1)),
    `Deployment` LowCardinality(String) CODEC(ZSTD(1)),
    `Instance` LowCardinality(String) CODEC(ZSTD(1)),
    `K8SCluster` LowCardinality(String) CODEC(ZSTD(1)),
    `KubernetesNamespace` LowCardinality(String) CODEC(ZSTD(1)),
    `KubernetesNodeName` LowCardinality(String) CODEC(ZSTD(1)),
    `LabelApp` LowCardinality(String) CODEC(ZSTD(1)),
    `Message` LowCardinality(String) CODEC(ZSTD(1)),
    `MessageName` LowCardinality(String) CODEC(ZSTD(1)),
    `Device` LowCardinality(String) CODEC(ZSTD(1)),
    `Job` String CODEC(ZSTD(1)),
    `Node` LowCardinality(String) CODEC(ZSTD(1)),
    `Type` LowCardinality(String) CODEC(ZSTD(1)),
    `CephCluster` LowCardinality(String) CODEC(ZSTD(1)),
    `CephDaemon` LowCardinality(String) CODEC(ZSTD(1)),
    `HttpMethod` LowCardinality(String) CODEC(ZSTD(1)),
    `HttpStatus` LowCardinality(String) CODEC(ZSTD(1)),
    `Status` LowCardinality(String) CODEC(ZSTD(1)),
    `Platform` LowCardinality(String) CODEC(ZSTD(1)),
    `RelName` LowCardinality(String) CODEC(ZSTD(1)),
    `ReplicationRole` LowCardinality(String) CODEC(ZSTD(1)),
    `Role` LowCardinality(String) CODEC(ZSTD(1)),
    `Rule` LowCardinality(String) CODEC(ZSTD(1)),
    `SchemaName` LowCardinality(String) CODEC(ZSTD(1)),
    `StorageName` LowCardinality(String) CODEC(ZSTD(1)),
    `ReplicaSet` String CODEC(ZSTD(1)),
    `ReplicaSetName` LowCardinality(String) CODEC(ZSTD(1)),
    `Software` LowCardinality(String) CODEC(ZSTD(1)),
    `Topic` String CODEC(ZSTD(1)),
    `Reason` LowCardinality(String) CODEC(ZSTD(1)),
    `Condition` LowCardinality(String) CODEC(ZSTD(1)),
    `Phase` LowCardinality(String) CODEC(ZSTD(1)),
    `Resource` LowCardinality(String) CODEC(ZSTD(1)),
    `Unit` LowCardinality(String) CODEC(ZSTD(1))
)
ENGINE = ReplicatedReplacingMergeTree('/clickhouse/tables/replicator_common/graphite.tagged', '{replica}', Version)
PARTITION BY toYYYYMM(Date)
ORDER BY (Name, Aggregate, Namespace, Cluster, Env, Host, Hostname, Instance, Path, Date)
SETTINGS index_granularity = 8192