milovidov-desktop :) SELECT sum(x) FROM test_memory

SELECT sum(x)
FROM test_memory

Query id: 14833c4a-436f-40d6-8cce-f1a09db81158

┌─────sum(x)─┐
│ 1000000000 │
└────────────┘

1 rows in set. Elapsed: 0.140 sec. Processed 1.00 billion rows, 8.00 GB (7.13 billion rows/s., 57.04 GB/s.) 

milovidov-desktop :) SELECT sum(x) FROM test_memory_uncompressed

SELECT sum(x)
FROM test_memory_uncompressed

Query id: d11ce092-72a8-46c8-a75a-7275c45f1145

┌─────sum(x)─┐
│ 1000000000 │
└────────────┘

1 rows in set. Elapsed: 0.313 sec. Processed 1.00 billion rows, 8.00 GB (3.19 billion rows/s., 25.55 GB/s.) 

milovidov-desktop :) SELECT avg(blockSize()) FROM test.hits_memory WHERE NOT ignore(URL)

SELECT avg(blockSize())
FROM test.hits_memory
WHERE NOT ignore(URL)

Query id: 6b374325-c2dc-4693-8927-da1bdcd92f35

┌──avg(blockSize())─┐
│ 65419.37380889436 │
└───────────────────┘

1 rows in set. Elapsed: 0.071 sec. Processed 8.87 million rows, 767.95 MB (124.56 million rows/s., 10.78 GB/s.) 

milovidov-desktop :) SELECT avg(blockSize()) FROM test.hits WHERE NOT ignore(URL)

SELECT avg(blockSize())
FROM test.hits
WHERE NOT ignore(URL)

Query id: c7d4073d-e360-4427-90dd-410241a74944

┌──avg(blockSize())─┐
│ 9279.622728591201 │
└───────────────────┘

1 rows in set. Elapsed: 0.054 sec. Processed 8.87 million rows, 767.95 MB (163.13 million rows/s., 14.12 GB/s.)

milovidov-desktop :) SELECT avg(length(URL)) FROM test.hits

SELECT avg(length(URL))
FROM test.hits

Query id: 653b288b-eac0-4aed-b5b7-a39390870930

┌──avg(length(URL))─┐
│ 77.54074297450794 │
└───────────────────┘

1 rows in set. Elapsed: 0.053 sec. Processed 8.87 million rows, 767.95 MB (165.86 million rows/s., 14.35 GB/s.)