3 ms·
If you write it as an SQL query in ClickHouse, it will take only 0.170 seconds: SELECT sum(reinterpretAsFloat32(number) BETWEEN 0.0 AND 1.0) FROM numbers_m
by zX41ZdbW 4y ago
If you write it as an SQL query in ClickHouse, it will take only 0.170 seconds:
SELECT sum(reinterpretAsFloat32(number) BETWEEN 0.0 AND 1.0) FROM numbers_mt(0x100000000)
1 row in set. Elapsed: 0.170 sec. Processed 2.39 billion rows, 19.08 GB (14.02 billion rows/s., 112.13 GB/s.)