chdb 0.11.2

c6a.4xlarge

[0.18604542899998933,0.06962641699999494,0.06824182000002565],
[0.14916791100000637,0.06132458399997631,0.05951455799998939],
[0.2608729639999865,0.0958906479999655,0.09617753499998116],
[0.40878004000001056,0.09374836000000641,0.09378371100001459],
[0.6718334320000281,0.4345236620000037,0.4334162419999643],
[1.002973752999992,0.7015915819999918,0.7080588069999862],
[0.17497927499999832,0.0756155509999985,0.07616734799995584],
[0.1498642690000338,0.06664470100002973,0.06627480200000946],
[0.8478573819999156,0.6415576590000001,0.6571600359999366],
[1.4339677990000155,0.8019762860000128,0.7825285239999857],
[0.7129794380000476,0.29984710199994424,0.2986627179999459],
[0.7311982570000737,0.3551548640000419,0.3584088119999933],
[1.033043762000034,0.7542649460000348,0.759355203000041],
[2.4560109090000424,1.113515919000065,1.0977152020000176],
[1.201306127999942,0.8730847320000521,0.8964725619999854],
[0.8019850609999821,0.5918394020000051,0.5998019450000811],
[3.0425571000000673,2.1472388590000264,2.131523858000037],
[2.2881531939999604,1.364195564000056,1.3651125889999776],
[6.126621667999984,4.210806041999945,4.148955032999993],
[0.40682574300001306,0.09419107600001553,0.09233334599991849],
[9.37183620199994,1.6441978839999365,1.6582015100000262],
[11.07249543499995,2.104125450000083,2.120594202999996],
[21.586059143999933,5.120981125999947,5.101199570999938],
[55.784635826,17.611798978000024,17.51728781099996],
[2.6106269869999323,0.5292526870000529,0.45510037799999736],
[0.7932133639999392,0.424066119000031,0.4280758680000645],
[2.596399197999972,0.42785320100006174,0.43743377700002384],
[9.549912188999997,1.9688359930000843,1.9612207379999518],
[10.91492691399992,10.535358900999995,10.496279035999919],
[1.4205230750000055,1.3084790349998912,1.336332412000047],
[2.5722628119999627,0.850128912999935,0.8145080809999854],
[6.244212609999977,1.1159434999999576,1.1225396139999475],
[7.952969278999944,5.730464084000005,5.831898188999958],
[10.808299516000034,4.5159039010000015,4.554734548999932],
[10.697866138999984,4.50317994999989,4.518262995999976],
[1.2792195290001018,1.0222256680000328,1.01397522700006],
[9.917717786000026,1.9431002269999453,1.913905366999984],
[9.009406890000037,1.9050781859999688,1.9133741330000476],
[9.883221036999998,1.9681666479999649,1.9961536740000838],
[18.718810373999986,3.983699361000049,4.022733410000001],
[2.952012843000034,0.33922061200007647,0.32993713399991975],
[2.255466290000072,0.3035739989999229,0.2997916479999958],
[1.3341318800000863,0.3156538109999474,0.2525074740000264]

c6a.4xlarge 2th

[0.22381793099998504,0.06842008400008126,0.06704154900012327],
[0.1582648920000338,0.05954546900011337,0.05898548400000436],
[0.27694607800003723,0.0945129710000856,0.09569122199991398],
[0.4118199070001083,0.09301254100000733,0.09233870300022318],
[0.6638579680000021,0.4364185220001673,0.4438091889999214],
[1.0085423330001504,0.7057991869999114,0.7293260450001071],
[0.2224098750000394,0.07700480099993001,0.0744739629999458],
[0.21677301499994428,0.06650286200010669,0.06571470199992291],
[0.8440045919999193,0.6639980019999712,0.6691697779999686],
[1.3891953539998667,0.794705457000191,0.7916623250000612],
[0.6241423049998502,0.2980583309999929,0.30050318600001447],
[0.6967825299998367,0.3482780630001798,0.3493799510001736],
[1.0094738160000816,0.7634391789999881,0.7740093110000998],
[2.4310941139999613,1.1050711880000108,1.1089276799998515],
[1.1915427349999845,0.894389935000163,0.8782520919999115],
[0.8829752689998713,0.6071337769999445,0.6079767790001824],
[2.9891539920001833,2.1355581220000204,2.1603169039999557],
[2.2777959550001015,1.3542385830000967,1.3643068829999265],
[6.086212266000075,4.219517214999996,4.2434758599999896],
[0.4146596660000341,0.0947623960000783,0.0901330820001931],
[9.38162805800016,1.6979457759998695,1.6757436909999797],
[11.048174422000102,2.091421303000061,2.1154213150000487],
[21.566717572000016,5.045110783999917,5.027971854999805],
[55.797478170999966,17.599457983999855,17.526357237999946],
[2.627713361000133,0.518861840999989,0.4528507160000572],
[0.8474187700001039,0.42326875000003383,0.42237686500016025],
[2.5874297499999557,0.44073721600011595,0.4306359259999226],
[9.568268125000031,1.9762331709998762,1.9575607100000525],
[10.90278145100001,10.510137835000023,10.472751512000059],
[1.3879380399998809,1.3252051070001016,1.3226138980000997],
[2.5809780409999803,0.8234438039999077,0.8280143560000397],
[6.236401442999977,1.1019247369999903,1.1276056520000566],
[7.850038996999956,5.783244540999931,5.771445728999879],
[10.732769968999946,4.544210622000037,4.559326447999865],
[10.789127108000002,4.540633754000055,4.565290144000073],
[1.3787602380000408,0.9575001739999607,0.9574486530000286],
[9.910545346000163,1.9124885840001298,1.9129989089997252],
[8.994437757000014,1.8979225449998012,1.9075664219999453],
[9.885178918999827,1.9432095799998024,1.9770044800002324],
[18.786196257999563,4.122344891000012,4.042122396000195],
[2.997746877999816,0.3387378580000586,0.3383676690000357],
[2.185897670000031,0.30818997300002593,0.3009178000002066],
[1.310836406999897,0.31825963199980833,0.2564000639999904]

c6a.4xlarge 3th

[0.19524067700012893,0.06805416600036551,0.06862046000014743],
[0.18713751199993567,0.061116349999792874,0.05978165499982424],
[0.24714559100038969,0.09776336599998103,0.09662702699961301],
[0.44192348600017795,0.09502709499975026,0.09377156000027753],
[0.6367149159996188,0.44109867799988933,0.44346165199976895],
[0.9820497699997759,0.7133898120000595,0.7239109520000966],
[0.19104063799977666,0.0768110090002665,0.07381240999984584],
[0.16606279999996332,0.06637568199994348,0.06564434100027938],
[0.8872927120000895,0.6428484600000957,0.6442639890001374],
[1.411543158999848,0.7911860089998299,0.7946820109996224],
[0.67430446499975,0.3068963310001891,0.30223715700003595],
[0.6969398679998449,0.3534990729999663,0.3538015720000658],
[1.0042422209999131,0.7511497450000206,0.7503392630001144],
[2.433781000000181,1.1062255599999844,1.1023842770000556],
[1.172083835000194,0.892967224000131,0.8839513830002943],
[0.7994709619997593,0.616992965999998,0.6049380159997781],
[3.0131493490002867,2.1462694110000484,2.1387468110001464],
[2.26977342400005,1.3686911150002743,1.34626821799975],
[6.171935515999849,4.2103287350000755,4.217882295999971],
[0.4031385170001158,0.09533733000034772,0.0892092269996283],
[9.375324885000282,1.6756357650001519,1.6741780069996821],
[11.076184659999853,2.128820712999641,2.1739722530001018],
[21.6407123580002,5.114125033000164,5.108208247000221],
[55.87356212299983,17.58068791000005,17.57565402399996],
[2.614406410999891,0.5120710099999997,0.46498612599998523],
[0.7863429460003317,0.42348521100029757,0.43300039499990817],
[2.602814822000255,0.44343555099976584,0.43750326399958794],
[9.71377530699965,1.972595003999686,1.959637346999898],
[10.784216015999846,10.466111053000077,10.555802843000038],
[1.3692328009997254,1.3081574349998846,1.332320317000267],
[2.644299434000004,0.8246330199999647,0.821856377000131],
[6.251876720999917,1.0974203490000036,1.139532080999743],
[7.854966180000247,5.729893386000185,5.78614391300016],
[10.739148268000008,4.508653823000259,4.564696363999701],
[10.680724387000282,4.516160334999768,4.574974142999963],
[1.2756228950001969,1.0200801439996212,0.9727186340001026],
[9.96628616399994,1.9443010969998795,1.922021031999975],
[9.032980100999794,1.927749988999949,1.9037755200001811],
[9.898962439000115,1.9682554390001314,1.9482439650000742],
[18.740200772000208,4.0117254980000325,4.044647227000041],
[2.9419422959999793,0.32916521800007104,0.33302920100004485],
[2.18409511200025,0.308339801999864,0.3011338210003487],
[1.3033133579997411,0.32010687599995435,0.25164426800029105]

c6a.4xlarge log

SELECT COUNT(*) FROM file("hits_*.parquet", Parquet);

0.18604542899998933
0.06962641699999494
0.06824182000002565
SELECT COUNT(*) FROM file("hits_*.parquet", Parquet) WHERE AdvEngineID <> 0;

0.14916791100000637
0.06132458399997631
0.05951455799998939
SELECT SUM(AdvEngineID), COUNT(*), AVG(ResolutionWidth) FROM file("hits_*.parquet", Parquet);

0.2608729639999865
0.0958906479999655
0.09617753499998116
SELECT AVG(UserID) FROM file("hits_*.parquet", Parquet);

0.40878004000001056
0.09374836000000641
0.09378371100001459
SELECT COUNT(DISTINCT UserID) FROM file("hits_*.parquet", Parquet);

0.6718334320000281
0.4345236620000037
0.4334162419999643
SELECT COUNT(DISTINCT SearchPhrase) FROM file("hits_*.parquet", Parquet);

1.002973752999992
0.7015915819999918
0.7080588069999862
SELECT MIN(EventDate), MAX(EventDate) FROM file("hits_*.parquet", Parquet);

0.17497927499999832
0.0756155509999985
0.07616734799995584
SELECT AdvEngineID, COUNT(*) FROM file("hits_*.parquet", Parquet) WHERE AdvEngineID <> 0 GROUP BY AdvEngineID ORDER BY COUNT(*) DESC;

0.1498642690000338
0.06664470100002973
0.06627480200000946
SELECT RegionID, COUNT(DISTINCT UserID) AS u FROM file("hits_*.parquet", Parquet) GROUP BY RegionID ORDER BY u DESC LIMIT 10;

0.8478573819999156
0.6415576590000001
0.6571600359999366
SELECT RegionID, SUM(AdvEngineID), COUNT(*) AS c, AVG(ResolutionWidth), COUNT(DISTINCT UserID) FROM file("hits_*.parquet", Parquet) GROUP BY
RegionID ORDER BY c DESC LIMIT 10;

1.4339677990000155
0.8019762860000128
0.7825285239999857
SELECT MobilePhoneModel, COUNT(DISTINCT UserID) AS u FROM file("hits_*.parquet", Parquet) WHERE MobilePhoneModel <> '' GROUP BY MobilePhoneModel ORDER BY u DESC LIMIT 10;

0.7129794380000476
0.29984710199994424
0.2986627179999459
SELECT MobilePhone, MobilePhoneModel, COUNT(DISTINCT UserID) AS u FROM file("hits_*.parquet", Parquet) WHERE MobilePhoneModel <> '' GROUP BY
MobilePhone, MobilePhoneModel ORDER BY u DESC LIMIT 10;

0.7311982570000737
0.3551548640000419
0.3584088119999933
SELECT SearchPhrase, COUNT(*) AS c FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT
10;

1.033043762000034
0.7542649460000348
0.759355203000041
SELECT SearchPhrase, COUNT(DISTINCT UserID) AS u FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY u DESC LIMIT 10;

2.4560109090000424
1.113515919000065
1.0977152020000176
SELECT SearchEngineID, SearchPhrase, COUNT(*) AS c FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase <> '' GROUP BY SearchEngineID, SearchPhrase ORDER BY c DESC LIMIT 10;

1.201306127999942
0.8730847320000521
0.8964725619999854
SELECT UserID, COUNT(*) FROM file("hits_*.parquet", Parquet) GROUP BY UserID ORDER BY COUNT(*) DESC LIMIT 10;

0.8019850609999821
0.5918394020000051
0.5998019450000811
SELECT UserID, SearchPhrase, COUNT(*) FROM file("hits_*.parquet", Parquet) GROUP BY UserID, SearchPhrase ORDER BY COUNT(*) DESC LIMIT 10;

3.0425571000000673
2.1472388590000264
2.131523858000037
SELECT UserID, SearchPhrase, COUNT(*) FROM file("hits_*.parquet", Parquet) GROUP BY UserID, SearchPhrase LIMIT 10;

2.2881531939999604
1.364195564000056
1.3651125889999776
SELECT UserID, extract(minute FROM toDateTime(EventTime)) AS m, SearchPhrase, COUNT(*) FROM file("hits_*.parquet", Parquet) GROUP BY UserID,
m, SearchPhrase ORDER BY COUNT(*) DESC LIMIT 10;

6.126621667999984
4.210806041999945
4.148955032999993
SELECT UserID FROM file("hits_*.parquet", Parquet) WHERE UserID = 435090932899640449;

0.40682574300001306
0.09419107600001553
0.09233334599991849
SELECT COUNT(*) FROM file("hits_*.parquet", Parquet) WHERE URL LIKE '%google%';

9.37183620199994
1.6441978839999365
1.6582015100000262
SELECT SearchPhrase, MIN(URL), COUNT(*) AS c FROM file("hits_*.parquet", Parquet) WHERE URL LIKE '%google%' AND SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;

11.07249543499995
2.104125450000083
2.120594202999996
SELECT SearchPhrase, MIN(URL), MIN(Title), COUNT(*) AS c, COUNT(DISTINCT UserID) FROM file("hits_*.parquet", Parquet) WHERE Title LIKE '%Google%' AND URL NOT LIKE '%.google.%' AND SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;

21.586059143999933
5.120981125999947
5.101199570999938
SELECT * FROM file("hits_*.parquet", Parquet) WHERE URL LIKE '%google%' ORDER BY EventTime LIMIT 10;

55.784635826
17.611798978000024
17.51728781099996
SELECT SearchPhrase FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase <> '' ORDER BY EventTime LIMIT 10;

2.6106269869999323
0.5292526870000529
0.45510037799999736
SELECT SearchPhrase FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase <> '' ORDER BY SearchPhrase LIMIT 10;

0.7932133639999392
0.424066119000031
0.4280758680000645
SELECT SearchPhrase FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase <> '' ORDER BY EventTime, SearchPhrase LIMIT 10;

2.596399197999972
0.42785320100006174
0.43743377700002384
SELECT CounterID, AVG(length(URL)) AS l, COUNT(*) AS c FROM file("hits_*.parquet", Parquet) WHERE URL <> '' GROUP BY CounterID HAVING COUNT(*) > 100000 ORDER BY l DESC LIMIT 25;

9.549912188999997
1.9688359930000843
1.9612207379999518
SELECT REGEXP_REPLACE(Referer, '^https?://(?:www.)?([^/]+)/.*$', '1') AS k, AVG(length(Referer)) AS l, COUNT(*) AS c, MIN(Referer) FROM file("hits_*.parquet", Parquet) WHERE Referer <> '' GROUP BY k HAVING COUNT(*) > 100000 ORDER BY l DESC LIMIT 25;

10.91492691399992
10.535358900999995
10.496279035999919
SELECT SUM(ResolutionWidth), SUM(ResolutionWidth + 1), SUM(ResolutionWidth + 2), SUM(ResolutionWidth + 3), SUM(ResolutionWidth + 4), SUM(ResolutionWidth + 5), SUM(ResolutionWidth + 6), SUM(ResolutionWidth + 7), SUM(ResolutionWidth + 8), SUM(ResolutionWidth + 9), SUM(ResolutionWidth + 10), SUM(ResolutionWidth + 11), SUM(ResolutionWidth + 12), SUM(ResolutionWidth + 13), SUM(ResolutionWidth + 14), SUM(ResolutionWidth + 15), SUM(ResolutionWidth + 16), SUM(ResolutionWidth + 17), SUM(ResolutionWidth + 18), SUM(ResolutionWidth + 19), SUM(ResolutionWidth + 20), SUM(ResolutionWidth + 21), SUM(ResolutionWidth + 22), SUM(ResolutionWidth + 23), SUM(ResolutionWidth + 24), SUM(ResolutionWidth + 25), SUM(ResolutionWidth + 26), SUM(ResolutionWidth + 27), SUM(ResolutionWidth + 28), SUM(ResolutionWidth + 29), SUM(ResolutionWidth + 30), SUM(ResolutionWidth + 31), SUM(ResolutionWidth + 32), SUM(ResolutionWidth + 33), SUM(ResolutionWidth + 34), SUM(ResolutionWidth + 35), SUM(ResolutionWidth +
36), SUM(ResolutionWidth + 37), SUM(ResolutionWidth + 38), SUM(ResolutionWidth + 39), SUM(ResolutionWidth + 40), SUM(ResolutionWidth + 41), SUM(ResolutionWidth + 42), SUM(ResolutionWidth + 43), SUM(ResolutionWidth + 44), SUM(ResolutionWidth + 45), SUM(ResolutionWidth + 46), SUM(ResolutionWidth + 47), SUM(ResolutionWidth + 48), SUM(ResolutionWidth + 49), SUM(ResolutionWidth + 50), SUM(ResolutionWidth + 51), SUM(ResolutionWidth + 52), SUM(ResolutionWidth + 53), SUM(ResolutionWidth + 54), SUM(ResolutionWidth + 55), SUM(ResolutionWidth + 56), SUM(ResolutionWidth + 57), SUM(ResolutionWidth + 58), SUM(ResolutionWidth + 59), SUM(ResolutionWidth + 60), SUM(ResolutionWidth + 61), SUM(ResolutionWidth + 62), SUM(ResolutionWidth + 63), SUM(ResolutionWidth + 64), SUM(ResolutionWidth + 65), SUM(ResolutionWidth + 66), SUM(ResolutionWidth + 67), SUM(ResolutionWidth + 68), SUM(ResolutionWidth + 69), SUM(ResolutionWidth + 70), SUM(ResolutionWidth + 71), SUM(ResolutionWidth + 72), SUM(ResolutionWidth + 73), SUM(ResolutionWidth + 74), SUM(ResolutionWidth + 75), SUM(ResolutionWidth + 76), SUM(ResolutionWidth + 77), SUM(ResolutionWidth + 78), SUM(ResolutionWidth + 79), SUM(ResolutionWidth + 80), SUM(ResolutionWidth + 81), SUM(ResolutionWidth + 82), SUM(ResolutionWidth +
83), SUM(ResolutionWidth + 84), SUM(ResolutionWidth + 85), SUM(ResolutionWidth + 86), SUM(ResolutionWidth + 87), SUM(ResolutionWidth + 88), SUM(ResolutionWidth + 89) FROM file("hits_*.parquet", Parquet);

1.4205230750000055
1.3084790349998912
1.336332412000047
SELECT SearchEngineID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth) FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase
<> '' GROUP BY SearchEngineID, ClientIP ORDER BY c DESC LIMIT 10;

2.5722628119999627
0.850128912999935
0.8145080809999854
SELECT WatchID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth) FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase <> '' GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10;

6.244212609999977
1.1159434999999576
1.1225396139999475
SELECT WatchID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth) FROM file("hits_*.parquet", Parquet) GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10;

7.952969278999944
5.730464084000005
5.831898188999958
SELECT URL, COUNT(*) AS c FROM file("hits_*.parquet", Parquet) GROUP BY URL ORDER BY c DESC LIMIT 10;

10.808299516000034
4.5159039010000015
4.554734548999932
SELECT 1, URL, COUNT(*) AS c FROM file("hits_*.parquet", Parquet) GROUP BY 1, URL ORDER BY c DESC LIMIT 10;

10.697866138999984
4.50317994999989
4.518262995999976
SELECT ClientIP, ClientIP - 1, ClientIP - 2, ClientIP - 3, COUNT(*) AS c FROM file("hits_*.parquet", Parquet) GROUP BY ClientIP, ClientIP - 1, ClientIP - 2, ClientIP - 3 ORDER BY c DESC LIMIT 10;

1.2792195290001018
1.0222256680000328
1.01397522700006
SELECT URL, COUNT(*) AS PageViews FROM file("hits_*.parquet", Parquet) WHERE CounterID = 62  AND toDate(EventDate) >= '2013-07-01'  AND toDate(EventDate) <= '2013-07-31' AND DontCountHits = 0 AND IsRefresh = 0 AND URL <> '' GROUP BY URL ORDER BY PageViews DESC LIMIT 10;

9.917717786000026
1.9431002269999453
1.913905366999984
SELECT Title, COUNT(*) AS PageViews FROM file("hits_*.parquet", Parquet) WHERE CounterID = 62  AND toDate(EventDate) >= '2013-07-01'  AND toDate(EventDate) <= '2013-07-31' AND DontCountHits = 0 AND IsRefresh = 0 AND Title <> '' GROUP BY Title ORDER BY PageViews DESC LIMIT 10;

9.009406890000037
1.9050781859999688
1.9133741330000476
SELECT URL, COUNT(*) AS PageViews FROM file("hits_*.parquet", Parquet) WHERE CounterID = 62  AND toDate(EventDate) >= '2013-07-01'  AND toDate(EventDate) <= '2013-07-31' AND IsRefresh = 0 AND IsLink <> 0 AND IsDownload = 0 GROUP BY URL ORDER BY PageViews DESC LIMIT 10 OFFSET 1000;

9.883221036999998
1.9681666479999649
1.9961536740000838
SELECT TraficSourceID, SearchEngineID, AdvEngineID, CASE WHEN (SearchEngineID = 0 AND AdvEngineID = 0) THEN Referer ELSE '' END AS Src, URL AS Dst, COUNT(*) AS PageViews FROM file("hits_*.parquet", Parquet) WHERE CounterID = 62  AND toDate(EventDate) >= '2013-07-01'  AND toDate(EventDate) <= '2013-07-31' AND IsRefresh = 0 GROUP BY TraficSourceID, SearchEngineID, AdvEngineID, Src, Dst ORDER BY PageViews DESC LIMIT 10 OFFSET 1000;

18.718810373999986
3.983699361000049
4.022733410000001
SELECT URLHash, EventDate, COUNT(*) AS PageViews FROM file("hits_*.parquet", Parquet) WHERE CounterID = 62  AND toDate(EventDate) >= '2013-07-01'  AND toDate(EventDate) <= '2013-07-31' AND IsRefresh = 0 AND TraficSourceID IN (-1, 6) AND RefererHash = 3594120000172545465 GROUP BY URLHash, EventDate ORDER BY PageViews DESC LIMIT 10 OFFSET 100;

2.952012843000034
0.33922061200007647
0.32993713399991975
SELECT WindowClientWidth, WindowClientHeight, COUNT(*) AS PageViews FROM file("hits_*.parquet", Parquet) WHERE CounterID = 62  AND toDate(EventDate) >= '2013-07-01'  AND toDate(EventDate) <= '2013-07-31' AND IsRefresh = 0 AND DontCountHits = 0 AND URLHash = 2868770270353813622 GROUP BY WindowClientWidth, WindowClientHeight ORDER BY PageViews DESC LIMIT 10 OFFSET 10000;

2.255466290000072
0.3035739989999229
0.2997916479999958
SELECT DATE_TRUNC('minute', toDateTime(EventTime)) AS M, COUNT(*) AS PageViews FROM file("hits_*.parquet", Parquet) WHERE CounterID = 62  AND toDate(EventDate) >= '2013-07-14'  AND toDate(EventDate) <= '2013-07-15' AND IsRefresh = 0 AND DontCountHits = 0 GROUP BY DATE_TRUNC('minute', toDateTime(EventTime)) ORDER BY DATE_TRUNC('minute', toDateTime(EventTime)) LIMIT 10 OFFSET 1000;

1.3341318800000863
0.3156538109999474
0.2525074740000264

meta

[0.2703915179999967,0.15309164799998598,0.20953606500000888],
[0.3234831199999917,0.21767541500003063,0.1988284930000077],
[0.42175294999998414,0.23309840900003564,0.12865629600003103],
[0.5582606619999524,0.2557465259999958,0.15091527499998847],
[1.0677276979999988,0.6597591180000109,0.5390796920000298],
[1.5947761599999808,1.1698713209999596,1.1476144590000104],
[0.2518611190000115,0.20570339400001103,0.1915426350000189],
[0.31361394399999654,0.22946803599995746,0.26369060199999694],
[0.8721256499999868,0.537654697999983,0.4433740220000004],
[1.6835474999999747,0.5437257770000201,0.6134966970000164],
[0.9989418810000075,0.9014724290000231,0.8459155999999552],
[1.0032960780000053,0.8986043109999855,0.8735780409999734],
[0.985532534000015,0.8489836620000233,0.8289598040000214],
[2.2272995310000283,0.98451817199998,0.9578938950000406],
[0.987545965000038,0.8702441410000006,0.8671060060000286],
[0.7000677180000139,0.3105725920000282,0.31735810200001424],
[2.4214189869999814,1.1958077419999995,1.0889407420000339],
[2.4298563899999976,0.9725546080000527,0.982419526000001],
[4.692132377999997,1.4577632119999748,1.6054368549999936],
[0.5267076249999718,0.2671152789999951,0.12936606299996356],
[9.522279940999965,0.7814665059999584,0.7569029730000238],
[11.520670462999988,1.3437582340000063,1.3496014559999594],
[21.83269422799998,1.9744985130000146,1.9338837869999566],
[56.21921761499999,21.392936462999955,21.75163458199995],
[2.8088843399999632,0.7757808789999672,0.7404952780000258],
[0.8641101050000088,0.6351576700000123,0.6530913759999066],
[2.8547813860000133,0.7221077200000536,0.756638348000024],
[9.693734923999955,0.7827415529999371,0.7160810720000654],
[8.114493570999912,1.3044808899999225,1.2568237730000646],
[0.9738453390000359,0.6579482050000252,0.6571350059999759],
[2.7672302649999665,0.9708811919999789,0.965659376000076],
[6.110432331999959,1.097183470999994,1.1003876969999737],
[5.603500646000043,1.6594495909999978,1.6897149520000312],
[10.270947015999923,1.3653239940000503,1.633695892999981],
[10.396103089999997,1.5027754139999843,1.6142110910000156],
[0.8272786420000102,0.36963923299992985,0.40997371500009194],
[10.249519512999996,0.8722301960000323,0.915897665999978],
[9.375183412999945,0.8650518229999307,0.9473312289999285],
[10.068810299000006,0.9211436159999948,1.0894390919999069],
[18.877554996999947,1.467249799000001,1.4921866419999787],
[3.1356353820000322,0.5014155290000417,0.5182974469998953],
[2.333198793000065,0.5146134909999773,0.5243091449999611],
[1.6455634000000146,0.4842322739999645,0.3937952670000868]

meta 2th

[0.302766955999914,0.19755662700003995,0.21830434200001037],
[0.2913004100000762,0.24790970899994136,0.1830172920001587],
[0.4292974970001069,0.2151009609999619,0.17090478800014353],
[0.625403045999974,0.24436374600009003,0.14224033699997563],
[1.0842536529999052,0.561784753999973,0.4882232150000618],
[1.6454514500001096,1.2124891910000315,1.2450817260000804],
[0.30905277199985903,0.2689364539999133,0.12482095400014259],
[0.3037996360001216,0.2421650020000925,0.24525097100013227],
[0.8579592429998684,0.45897006400014106,0.48542993099999876],
[1.5909331730001668,0.61892396799999,0.5961555119999957],
[1.0446430069998769,0.9078375499998401,0.8930723559999478],
[0.9551285479999478,0.8494638360000408,0.9108623339998303],
[1.0106638370000383,0.8315808160000415,0.8601377850000063],
[2.2970697159998963,0.9500120150000839,0.908887937000145],
[1.2561832369999593,0.8482317989999046,0.8721020969999245],
[0.6992591599998832,0.42640566900013255,0.3072894299998552],
[2.413491998999916,1.1428185769998436,1.1274336639999092],
[2.471297684999854,1.036973001999968,1.0011195139998108],
[4.6145247389999895,1.5436948379999649,1.5639087449999352],
[0.5114364010000827,0.2857448199999908,0.13950388500006738],
[9.531514544999936,0.7966188120001334,0.6997982450000109],
[11.425263070000028,1.3501582889998645,1.2996041429998968],
[21.803210630999956,1.8999347940000462,1.9163478200000554],
[56.257798955,21.529130920999933,21.30510778200005],
[2.781064000000015,0.8006617169999117,0.7092485010000473],
[0.8287528810001277,0.5978622380000616,0.6268523150001784],
[2.8609759229998417,0.7611864689999948,0.7311526420000973],
[9.875189242000033,0.7752101779999521,0.7515662470000279],
[8.1061820299999,1.276070652000044,1.2675198970000565],
[0.8317975689999457,0.6589731109997956,0.6534763399999974],
[2.496289008000076,1.0388181139999233,0.9954522079999606],
[6.185625303000052,1.1368196060000173,1.113057008999931],
[5.483091130000048,1.6801995680000346,1.6127487840001322],
[10.267716742000175,1.6096890470000744,1.408994254000163],
[10.118996110999888,1.8768469350000032,1.6982510479999746],
[0.7894121530000575,0.5645295839999562,0.4117413110000143],
[10.202264779000188,0.886141877,0.9092021609999392],
[9.393150326000068,0.8673358830001234,0.9263450979999561],
[10.02926758500007,1.043489210999951,1.0222510819999115],
[19.03725743699988,1.3911756810000497,1.447149169999875],
[3.0006877619998704,0.4940635369998745,0.4842476850001276],
[2.209843899999896,0.5628366309999819,0.527214832000027],
[1.5382748489998903,0.47898262599983354,0.4219500290000724]

meta 3th

[0.38069409199988513,0.19103487699999278,0.12850805099992613],
[0.33911193799985995,0.22895092099997782,0.11505759100009527],
[0.35564611999984663,0.21255386200004978,0.1737371520000579],
[0.5397988980000719,0.24328324800012524,0.17142928099997334],
[0.995789430999821,0.73553929600007,0.49166479700011223],
[1.4588838480001414,1.2296203650000734,1.152208748000021],
[0.3192980339999849,0.1668846840000242,0.1842086990000098],
[0.2885520089998863,0.24011003800001163,0.21898864200011303],
[1.0788419850000537,0.455731293999861,0.48048144499989576],
[1.4392524849999973,0.6113256219998675,0.5681294019998404],
[1.3261462509999546,0.8787367259999428,0.8558326259999376],
[1.1913702850001755,0.8542427110000972,0.8640325310000208],
[0.9616620659999171,0.873552989000018,0.8852183290000539],
[2.27938632900009,0.9842065919999641,1.0381299539999418],
[1.02363696600014,0.8822550209999918,0.8445489069999894],
[0.6991922130000603,0.3692418169998746,0.33518693500013796],
[2.3624638310000137,1.152683862999993,1.098791004000077],
[2.461725930000057,1.044622261999848,1.0376712259999294],
[4.806326869000259,1.5491149839999707,1.609542596999745],
[0.5722210600001745,0.2575241019999339,0.13601550099974702],
[9.49920454400035,0.7822103569997125,0.7410564340002566],
[11.425835854999605,1.3353868809999767,1.30757918900008],
[21.837656744000014,1.9242553909998605,1.967242203999831],
[56.156024506999984,21.48768264699993,21.431284384000264],
[2.9600226379998276,0.7909586649998346,0.7384574339998835],
[0.7895070530003068,0.6491926869998679,0.6265708490000179],
[2.810873163999986,0.7313045630003217,0.7938516499998514],
[9.698009285000353,0.7579093949998423,0.7330222559999129],
[8.20063355100001,1.2968396820001544,1.2546536800000467],
[0.8721851700001935,0.6750778329997047,0.6413627120000456],
[2.571571194000171,1.0190507339998476,1.0313472200000433],
[6.290379204000146,1.0968148430001747,1.1199258159999772],
[5.469300647999717,1.583413156000006,1.727616227999988],
[10.100471054000081,1.654667881000023,1.6340000589998454],
[10.315470202999677,1.4900139950000266,1.6046943259998443],
[0.7941551160001836,0.49248007999995025,0.43137188099990453],
[10.069888068000182,0.9159308099997361,0.9579691099997945],
[9.122137128999839,0.897513784000239,0.9531601349999619],
[10.171681414999966,0.9799418510001487,0.9874499510001442],
[18.92793583699995,1.3966511720000199,1.447470711999813],
[3.1953806420001456,0.5236644510000588,0.496286863000023],
[2.459950461999597,0.5532330379996893,0.537363713999639],
[1.6365517280000859,0.46881788300015614,0.3981675019999784]

meta log

SELECT COUNT(*) FROM file("hits_*.parquet", Parquet);

0.2703915179999967
0.15309164799998598
0.20953606500000888
SELECT COUNT(*) FROM file("hits_*.parquet", Parquet) WHERE AdvEngineID <> 0;

0.3234831199999917
0.21767541500003063
0.1988284930000077
SELECT SUM(AdvEngineID), COUNT(*), AVG(ResolutionWidth) FROM file("hits_*.parquet", Parquet);

0.42175294999998414
0.23309840900003564
0.12865629600003103
SELECT AVG(UserID) FROM file("hits_*.parquet", Parquet);

0.5582606619999524
0.2557465259999958
0.15091527499998847
SELECT COUNT(DISTINCT UserID) FROM file("hits_*.parquet", Parquet);

1.0677276979999988
0.6597591180000109
0.5390796920000298
SELECT COUNT(DISTINCT SearchPhrase) FROM file("hits_*.parquet", Parquet);

1.5947761599999808
1.1698713209999596
1.1476144590000104
SELECT MIN(EventDate), MAX(EventDate) FROM file("hits_*.parquet", Parquet);

0.2518611190000115
0.20570339400001103
0.1915426350000189
SELECT AdvEngineID, COUNT(*) FROM file("hits_*.parquet", Parquet) WHERE AdvEngineID <> 0 GROUP BY AdvEngineID ORDER BY COUNT(*) DESC;

0.31361394399999654
0.22946803599995746
0.26369060199999694
SELECT RegionID, COUNT(DISTINCT UserID) AS u FROM file("hits_*.parquet", Parquet) GROUP BY RegionID ORDER BY u DESC LIMIT 10;

0.8721256499999868
0.537654697999983
0.4433740220000004
SELECT RegionID, SUM(AdvEngineID), COUNT(*) AS c, AVG(ResolutionWidth), COUNT(DISTINCT UserID) FROM file("hits_*.parquet", Parquet) GROUP BY
RegionID ORDER BY c DESC LIMIT 10;

1.6835474999999747
0.5437257770000201
0.6134966970000164
SELECT MobilePhoneModel, COUNT(DISTINCT UserID) AS u FROM file("hits_*.parquet", Parquet) WHERE MobilePhoneModel <> '' GROUP BY MobilePhoneModel ORDER BY u DESC LIMIT 10;

0.9989418810000075
0.9014724290000231
0.8459155999999552
SELECT MobilePhone, MobilePhoneModel, COUNT(DISTINCT UserID) AS u FROM file("hits_*.parquet", Parquet) WHERE MobilePhoneModel <> '' GROUP BY
MobilePhone, MobilePhoneModel ORDER BY u DESC LIMIT 10;

1.0032960780000053
0.8986043109999855
0.8735780409999734
SELECT SearchPhrase, COUNT(*) AS c FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT
10;

0.985532534000015
0.8489836620000233
0.8289598040000214
SELECT SearchPhrase, COUNT(DISTINCT UserID) AS u FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY u DESC LIMIT 10;

2.2272995310000283
0.98451817199998
0.9578938950000406
SELECT SearchEngineID, SearchPhrase, COUNT(*) AS c FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase <> '' GROUP BY SearchEngineID, SearchPhrase ORDER BY c DESC LIMIT 10;

0.987545965000038
0.8702441410000006
0.8671060060000286
SELECT UserID, COUNT(*) FROM file("hits_*.parquet", Parquet) GROUP BY UserID ORDER BY COUNT(*) DESC LIMIT 10;

0.7000677180000139
0.3105725920000282
0.31735810200001424
SELECT UserID, SearchPhrase, COUNT(*) FROM file("hits_*.parquet", Parquet) GROUP BY UserID, SearchPhrase ORDER BY COUNT(*) DESC LIMIT 10;

2.4214189869999814
1.1958077419999995
1.0889407420000339
SELECT UserID, SearchPhrase, COUNT(*) FROM file("hits_*.parquet", Parquet) GROUP BY UserID, SearchPhrase LIMIT 10;

2.4298563899999976
0.9725546080000527
0.982419526000001
SELECT UserID, extract(minute FROM toDateTime(EventTime)) AS m, SearchPhrase, COUNT(*) FROM file("hits_*.parquet", Parquet) GROUP BY UserID,
m, SearchPhrase ORDER BY COUNT(*) DESC LIMIT 10;

4.692132377999997
1.4577632119999748
1.6054368549999936
SELECT UserID FROM file("hits_*.parquet", Parquet) WHERE UserID = 435090932899640449;

0.5267076249999718
0.2671152789999951
0.12936606299996356
SELECT COUNT(*) FROM file("hits_*.parquet", Parquet) WHERE URL LIKE '%google%';

9.522279940999965
0.7814665059999584
0.7569029730000238
SELECT SearchPhrase, MIN(URL), COUNT(*) AS c FROM file("hits_*.parquet", Parquet) WHERE URL LIKE '%google%' AND SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;

11.520670462999988
1.3437582340000063
1.3496014559999594
SELECT SearchPhrase, MIN(URL), MIN(Title), COUNT(*) AS c, COUNT(DISTINCT UserID) FROM file("hits_*.parquet", Parquet) WHERE Title LIKE '%Google%' AND URL NOT LIKE '%.google.%' AND SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;

21.83269422799998
1.9744985130000146
1.9338837869999566
SELECT * FROM file("hits_*.parquet", Parquet) WHERE URL LIKE '%google%' ORDER BY EventTime LIMIT 10;

56.21921761499999
21.392936462999955
21.75163458199995
SELECT SearchPhrase FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase <> '' ORDER BY EventTime LIMIT 10;

2.8088843399999632
0.7757808789999672
0.7404952780000258
SELECT SearchPhrase FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase <> '' ORDER BY SearchPhrase LIMIT 10;

0.8641101050000088
0.6351576700000123
0.6530913759999066
SELECT SearchPhrase FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase <> '' ORDER BY EventTime, SearchPhrase LIMIT 10;

2.8547813860000133
0.7221077200000536
0.756638348000024
SELECT CounterID, AVG(length(URL)) AS l, COUNT(*) AS c FROM file("hits_*.parquet", Parquet) WHERE URL <> '' GROUP BY CounterID HAVING COUNT(*) > 100000 ORDER BY l DESC LIMIT 25;

9.693734923999955
0.7827415529999371
0.7160810720000654
SELECT REGEXP_REPLACE(Referer, '^https?://(?:www.)?([^/]+)/.*$', '1') AS k, AVG(length(Referer)) AS l, COUNT(*) AS c, MIN(Referer) FROM file("hits_*.parquet", Parquet) WHERE Referer <> '' GROUP BY k HAVING COUNT(*) > 100000 ORDER BY l DESC LIMIT 25;

8.114493570999912
1.3044808899999225
1.2568237730000646
SELECT SUM(ResolutionWidth), SUM(ResolutionWidth + 1), SUM(ResolutionWidth + 2), SUM(ResolutionWidth + 3), SUM(ResolutionWidth + 4), SUM(ResolutionWidth + 5), SUM(ResolutionWidth + 6), SUM(ResolutionWidth + 7), SUM(ResolutionWidth + 8), SUM(ResolutionWidth + 9), SUM(ResolutionWidth + 10), SUM(ResolutionWidth + 11), SUM(ResolutionWidth + 12), SUM(ResolutionWidth + 13), SUM(ResolutionWidth + 14), SUM(ResolutionWidth + 15), SUM(ResolutionWidth + 16), SUM(ResolutionWidth + 17), SUM(ResolutionWidth + 18), SUM(ResolutionWidth + 19), SUM(ResolutionWidth + 20), SUM(ResolutionWidth + 21), SUM(ResolutionWidth + 22), SUM(ResolutionWidth + 23), SUM(ResolutionWidth + 24), SUM(ResolutionWidth + 25), SUM(ResolutionWidth + 26), SUM(ResolutionWidth + 27), SUM(ResolutionWidth + 28), SUM(ResolutionWidth + 29), SUM(ResolutionWidth + 30), SUM(ResolutionWidth + 31), SUM(ResolutionWidth + 32), SUM(ResolutionWidth + 33), SUM(ResolutionWidth + 34), SUM(ResolutionWidth + 35), SUM(ResolutionWidth +
36), SUM(ResolutionWidth + 37), SUM(ResolutionWidth + 38), SUM(ResolutionWidth + 39), SUM(ResolutionWidth + 40), SUM(ResolutionWidth + 41), SUM(ResolutionWidth + 42), SUM(ResolutionWidth + 43), SUM(ResolutionWidth + 44), SUM(ResolutionWidth + 45), SUM(ResolutionWidth + 46), SUM(ResolutionWidth + 47), SUM(ResolutionWidth + 48), SUM(ResolutionWidth + 49), SUM(ResolutionWidth + 50), SUM(ResolutionWidth + 51), SUM(ResolutionWidth + 52), SUM(ResolutionWidth + 53), SUM(ResolutionWidth + 54), SUM(ResolutionWidth + 55), SUM(ResolutionWidth + 56), SUM(ResolutionWidth + 57), SUM(ResolutionWidth + 58), SUM(ResolutionWidth + 59), SUM(ResolutionWidth + 60), SUM(ResolutionWidth + 61), SUM(ResolutionWidth + 62), SUM(ResolutionWidth + 63), SUM(ResolutionWidth + 64), SUM(ResolutionWidth + 65), SUM(ResolutionWidth + 66), SUM(ResolutionWidth + 67), SUM(ResolutionWidth + 68), SUM(ResolutionWidth + 69), SUM(ResolutionWidth + 70), SUM(ResolutionWidth + 71), SUM(ResolutionWidth + 72), SUM(ResolutionWidth + 73), SUM(ResolutionWidth + 74), SUM(ResolutionWidth + 75), SUM(ResolutionWidth + 76), SUM(ResolutionWidth + 77), SUM(ResolutionWidth + 78), SUM(ResolutionWidth + 79), SUM(ResolutionWidth + 80), SUM(ResolutionWidth + 81), SUM(ResolutionWidth + 82), SUM(ResolutionWidth +
83), SUM(ResolutionWidth + 84), SUM(ResolutionWidth + 85), SUM(ResolutionWidth + 86), SUM(ResolutionWidth + 87), SUM(ResolutionWidth + 88), SUM(ResolutionWidth + 89) FROM file("hits_*.parquet", Parquet);

0.9738453390000359
0.6579482050000252
0.6571350059999759
SELECT SearchEngineID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth) FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase
<> '' GROUP BY SearchEngineID, ClientIP ORDER BY c DESC LIMIT 10;

2.7672302649999665
0.9708811919999789
0.965659376000076
SELECT WatchID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth) FROM file("hits_*.parquet", Parquet) WHERE SearchPhrase <> '' GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10;

6.110432331999959
1.097183470999994
1.1003876969999737
SELECT WatchID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth) FROM file("hits_*.parquet", Parquet) GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10;

5.603500646000043
1.6594495909999978
1.6897149520000312
SELECT URL, COUNT(*) AS c FROM file("hits_*.parquet", Parquet) GROUP BY URL ORDER BY c DESC LIMIT 10;

10.270947015999923
1.3653239940000503
1.633695892999981
SELECT 1, URL, COUNT(*) AS c FROM file("hits_*.parquet", Parquet) GROUP BY 1, URL ORDER BY c DESC LIMIT 10;

10.396103089999997
1.5027754139999843
1.6142110910000156
SELECT ClientIP, ClientIP - 1, ClientIP - 2, ClientIP - 3, COUNT(*) AS c FROM file("hits_*.parquet", Parquet) GROUP BY ClientIP, ClientIP - 1, ClientIP - 2, ClientIP - 3 ORDER BY c DESC LIMIT 10;

0.8272786420000102
0.36963923299992985
0.40997371500009194
SELECT URL, COUNT(*) AS PageViews FROM file("hits_*.parquet", Parquet) WHERE CounterID = 62  AND toDate(EventDate) >= '2013-07-01'  AND toDate(EventDate) <= '2013-07-31' AND DontCountHits = 0 AND IsRefresh = 0 AND URL <> '' GROUP BY URL ORDER BY PageViews DESC LIMIT 10;

10.249519512999996
0.8722301960000323
0.915897665999978
SELECT Title, COUNT(*) AS PageViews FROM file("hits_*.parquet", Parquet) WHERE CounterID = 62  AND toDate(EventDate) >= '2013-07-01'  AND toDate(EventDate) <= '2013-07-31' AND DontCountHits = 0 AND IsRefresh = 0 AND Title <> '' GROUP BY Title ORDER BY PageViews DESC LIMIT 10;

9.375183412999945
0.8650518229999307
0.9473312289999285
SELECT URL, COUNT(*) AS PageViews FROM file("hits_*.parquet", Parquet) WHERE CounterID = 62  AND toDate(EventDate) >= '2013-07-01'  AND toDate(EventDate) <= '2013-07-31' AND IsRefresh = 0 AND IsLink <> 0 AND IsDownload = 0 GROUP BY URL ORDER BY PageViews DESC LIMIT 10 OFFSET 1000;

10.068810299000006
0.9211436159999948
1.0894390919999069
SELECT TraficSourceID, SearchEngineID, AdvEngineID, CASE WHEN (SearchEngineID = 0 AND AdvEngineID = 0) THEN Referer ELSE '' END AS Src, URL AS Dst, COUNT(*) AS PageViews FROM file("hits_*.parquet", Parquet) WHERE CounterID = 62  AND toDate(EventDate) >= '2013-07-01'  AND toDate(EventDate) <= '2013-07-31' AND IsRefresh = 0 GROUP BY TraficSourceID, SearchEngineID, AdvEngineID, Src, Dst ORDER BY PageViews DESC LIMIT 10 OFFSET 1000;

18.877554996999947
1.467249799000001
1.4921866419999787
SELECT URLHash, EventDate, COUNT(*) AS PageViews FROM file("hits_*.parquet", Parquet) WHERE CounterID = 62  AND toDate(EventDate) >= '2013-07-01'  AND toDate(EventDate) <= '2013-07-31' AND IsRefresh = 0 AND TraficSourceID IN (-1, 6) AND RefererHash = 3594120000172545465 GROUP BY URLHash, EventDate ORDER BY PageViews DESC LIMIT 10 OFFSET 100;

3.1356353820000322
0.5014155290000417
0.5182974469998953
SELECT WindowClientWidth, WindowClientHeight, COUNT(*) AS PageViews FROM file("hits_*.parquet", Parquet) WHERE CounterID = 62  AND toDate(EventDate) >= '2013-07-01'  AND toDate(EventDate) <= '2013-07-31' AND IsRefresh = 0 AND DontCountHits = 0 AND URLHash = 2868770270353813622 GROUP BY WindowClientWidth, WindowClientHeight ORDER BY PageViews DESC LIMIT 10 OFFSET 10000;

2.333198793000065
0.5146134909999773
0.5243091449999611
SELECT DATE_TRUNC('minute', toDateTime(EventTime)) AS M, COUNT(*) AS PageViews FROM file("hits_*.parquet", Parquet) WHERE CounterID = 62  AND toDate(EventDate) >= '2013-07-14'  AND toDate(EventDate) <= '2013-07-15' AND IsRefresh = 0 AND DontCountHits = 0 GROUP BY DATE_TRUNC('minute', toDateTime(EventTime)) ORDER BY DATE_TRUNC('minute', toDateTime(EventTime)) LIMIT 10 OFFSET 1000;

1.6455634000000146
0.4842322739999645
0.3937952670000868