Коллеги, можете пояснить поведение? SELECT database,

Question

Коллеги, можете пояснить поведение? SELECT database,

table,
arrayReduce('groupUniqArray', groupArray(partition_date)) AS partitions_for_delete,
length(partitions_for_delete) AS count_partition_for_delete
FROM system.parts
WHERE (database = 'default') AND (table = 'test') AND (active = 1) AND (toDate(replaceAll(partition, '\'', '') AS partition_date) < (today() - 20))
GROUP BY
database,
table

Ok.

0 rows in set. Elapsed: 0.071 sec.

SELECT
database,
table,
arrayReduce('groupUniqArray', groupArray(partition_date)) AS partitions_for_delete,
length(partitions_for_delete) AS count_partition_for_delete
FROM system.parts
WHERE (toDate(replaceAll(partition, '\'', '') AS partition_date) < (today() - 20)) AND (active = 1) AND (database = 'default') AND (table = 'test')
GROUP BY
database,
table

┌─database─┬─table───────────────┬─partitions_for_delete─┬─count_partition_for_delete─┐
│ default │ test │ ['2019-01-18'] │ 1 │
└──────────┴─────────────────────┴───────────────────────┴────────────────────────────┘

1 rows in set. Elapsed: 0.075 sec.

Два запроса, в которых откличается только порядок фильтров WHERE. Версия КХ 18.14.8

#backend #clickhouse #database #devops #programming #russian

0

08.02.2019

1 ответов

18 просмотров

Denny [Altinity] · Accepted Answer

Denny [Altinity]

а без groupArray / GROUP BY тоже так?

0

08.02.2019

184 похожих чатов

Коллеги, можете пояснить поведение? SELECT database,

1 ответов

Похожие вопросы