uniq

milovidov-desktop :) SELECT abs(uniq(sipHash64(number)) / 10000000 - 1) FROM numbers(10000000)

SELECT abs((uniq(sipHash64(number)) / 10000000) - 1)
FROM numbers(10000000)

Query id: ea428bba-53ff-40c9-848d-5eaa578c52ec

┌─abs(minus(divide(uniq(sipHash64(number)), 10000000), 1))─┐
│                                     0.004632100000000028 │
└──────────────────────────────────────────────────────────┘

1 rows in set. Elapsed: 0.228 sec. Processed 10.02 million rows, 80.18 MB (43.88 million rows/s., 351.03 MB/s.) 

milovidov-desktop :) SELECT abs(uniq(sipHash64(number)) / 1000000 - 1) FROM numbers(1000000)

SELECT abs((uniq(sipHash64(number)) / 1000000) - 1)
FROM numbers(1000000)

Query id: 1d42aab5-7e7e-425a-abcb-aadc1f13149a

┌─abs(minus(divide(uniq(sipHash64(number)), 1000000), 1))─┐
│                                     0.00456499999999993 │
└─────────────────────────────────────────────────────────┘

1 rows in set. Elapsed: 0.035 sec. Processed 1.05 million rows, 8.38 MB (30.27 million rows/s., 242.20 MB/s.) 

milovidov-desktop :) SELECT abs(uniq(sipHash64(number)) / 10000000 - 1) FROM numbers(10000000)

SELECT abs((uniq(sipHash64(number)) / 10000000) - 1)
FROM numbers(10000000)

Query id: 66897919-afc8-401e-92a1-44c143981cfa

┌─abs(minus(divide(uniq(sipHash64(number)), 10000000), 1))─┐
│                                     0.004632100000000028 │
└──────────────────────────────────────────────────────────┘

1 rows in set. Elapsed: 0.224 sec. Processed 10.02 million rows, 80.18 MB (44.69 million rows/s., 357.49 MB/s.) 

milovidov-desktop :) SELECT abs(uniq(sipHash64(number)) / 20000000 - 1) FROM numbers(20000000)

SELECT abs((uniq(sipHash64(number)) / 20000000) - 1)
FROM numbers(20000000)

Query id: 191394d7-7269-4496-b9e4-d949c0ffaaba

┌─abs(minus(divide(uniq(sipHash64(number)), 20000000), 1))─┐
│                                    0.0016458499999999487 │
└──────────────────────────────────────────────────────────┘

1 rows in set. Elapsed: 0.436 sec. Processed 20.04 million rows, 160.36 MB (45.95 million rows/s., 367.63 MB/s.) 

milovidov-desktop :) SELECT abs(uniq(sipHash64(number)) / 30000000 - 1) FROM numbers(30000000)

SELECT abs((uniq(sipHash64(number)) / 30000000) - 1)
FROM numbers(30000000)

Query id: 4e388a2a-165a-48b9-810a-5746a6c7dcc8

┌─abs(minus(divide(uniq(sipHash64(number)), 30000000), 1))─┐
│                                    0.0028550666666666835 │
└──────────────────────────────────────────────────────────┘

1 rows in set. Elapsed: 0.645 sec. Processed 30.00 million rows, 240.01 MB (46.50 million rows/s., 372.03 MB/s.) 

milovidov-desktop :) SELECT abs(uniq(sipHash64(number)) / 40000000 - 1) FROM numbers(40000000)

SELECT abs((uniq(sipHash64(number)) / 40000000) - 1)
FROM numbers(40000000)

Query id: 2f55f695-f0d7-44c8-be32-864d6c442783

┌─abs(minus(divide(uniq(sipHash64(number)), 40000000), 1))─┐
│                                   0.00009294999999998055 │
└──────────────────────────────────────────────────────────┘

1 rows in set. Elapsed: 0.824 sec. Processed 40.02 million rows, 320.19 MB (48.56 million rows/s., 388.48 MB/s.) 

milovidov-desktop :) SELECT abs(uniq(sipHash64(number)) / 50000000 - 1) FROM numbers(50000000)

SELECT abs((uniq(sipHash64(number)) / 50000000) - 1)
FROM numbers(50000000)

Query id: 45dce75e-3b9c-4b3f-9ae1-2032d739dada

┌─abs(minus(divide(uniq(sipHash64(number)), 50000000), 1))─┐
│                                    0.0044452200000000275 │
└──────────────────────────────────────────────────────────┘

1 rows in set. Elapsed: 1.069 sec. Processed 50.05 million rows, 400.37 MB (46.82 million rows/s., 374.60 MB/s.)