Всем привет! Словил странное поведение КХ select count() from action_distributed where

Question

Всем привет! Словил странное поведение КХ select count() from action_distributed where

date = '2019-03-10' and toHour(dateTime) = 1 and toMinute(dateTime) = 51 format Vertical

SELECT count()
FROM action_distributed
WHERE (date = '2019-03-10') AND (toHour(dateTime) = 1) AND (toMinute(dateTime) = 51)
FORMAT Vertical

Row 1:
──────
count(): 3294

1 rows in set. Elapsed: 0.027 sec. Processed 2.54 million rows, 10.58 MB (92.94 million rows/s., 386.41 MB/s.)

----------------------------------------------------

select count() from action_distributed where date = '2019-03-10' and dateTime >= '2019-03-10 01:50:00' and dateTime < '2019-03-10 02:00:00' format Vertical

SELECT count()
FROM action_distributed
WHERE (date = '2019-03-10') AND (dateTime >= '2019-03-10 01:50:00') AND (dateTime < '2019-03-10 02:00:00')
FORMAT Vertical

Row 1:
──────
count(): 0

1 rows in set. Elapsed: 0.019 sec. Processed 2.54 million rows, 14.74 MB (135.80 million rows/s., 786.73 MB/s.)

В чем может быть проблема?

ClickHouse server version 19.1.6 revision 54413

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

0

11.03.2019

1 ответов

13 просмотров

Denny [Altinity] · Accepted Answer

Denny [Altinity]

а Вы проверили дату в datetime поле в 3294 записях? Там точно 03-10 ? https://github.com/yandex/ClickHouse/issues/4312

0

11.03.2019

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

Всем привет! Словил странное поведение КХ select count() from action_distributed where

1 ответов

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