26 lines
693 B
Plaintext
26 lines
693 B
Plaintext
VERSION 1
|
|
NODE aggregate
|
|
SQL >
|
|
|
|
SELECT
|
|
workspaceId,
|
|
apiId,
|
|
keyId,
|
|
countIfState((deniedReason = '') OR (deniedReason IS NULL)) AS success,
|
|
countIfState(deniedReason = 'RATE_LIMITED') AS rateLimited,
|
|
countIfState(deniedReason = 'USAGE_EXCEEDED') AS usageExceeded,
|
|
toStartOfHour(fromUnixTimestamp64Milli(time)) AS time
|
|
FROM key_verifications
|
|
GROUP BY
|
|
workspaceId,
|
|
apiId,
|
|
keyId,
|
|
time
|
|
|
|
TYPE materialized
|
|
DATASOURCE verifications_hourly_mv
|
|
ENGINE "AggregatingMergeTree"
|
|
ENGINE_PARTITION_KEY "toYYYYMM(time)"
|
|
ENGINE_SORTING_KEY "workspaceId, apiId, time, keyId"
|
|
ENGINE_TTL "time + toIntervalDay(30)"
|