13 lines
312 B
Plaintext
13 lines
312 B
Plaintext
VERSION 1
|
|
NODE count
|
|
SQL >
|
|
|
|
SELECT count(*) as count
|
|
FROM key_verifications
|
|
where (deniedReason is null or deniedReason = '') and time > toUnixTimestamp64Milli(toDateTime64('2023-09-07 07:00:00', 3))
|
|
|
|
TYPE materialized
|
|
DATASOURCE mv__total_verifications
|
|
ENGINE "MergeTree"
|
|
ENGINE_SORTING_KEY "count"
|