CODEWITHSUNDEEP
mysqldatabasestatisticsgoogle-bigquery
haeki
haeki

Reputation: 152

Httparchive - BigQuery how to get median bytesTotal per year from 2010-2014

I am currently writing my bachelor theses about web performance and refer to some statistic on httparchive. As I would like to have a nice graph from 2010 to 2014 about bytesTotal, bytesCss and so on I tried to get the data out of BigQuery. The queries do work, but I am getting some results which do not fit to the graphics over at httparchive.org

HttpArchive

My goal is to have one value for bytesTotal 2010, one for 2011, one for 2012 and so on.

So I tried it with something like this:

SELECT NTH(50, quantiles(bytesTotal,101)) TOTAL_med, NTH(50, quantiles(bytesHtmlDoc,101))
HTMLDOC_med FROM [httparchive:runs.2010_11_15_pages], [httparchive:runs.2010_11_29_pages],
[httparchive:runs.2010_12_16_pages], [httparchive:runs.2010_12_28_pages];


SELECT AVG(bytesTotal) TOTAL_med, AVG(bytesHtmlDoc) HTMLDOC_med FROM [httparchive:runs.2010_11_15_pages],
[httparchive:runs.2010_11_29_pages], [httparchive:runs.2010_12_16_pages],
[httparchive:runs.2010_12_28_pages];

So medians would be nice, but if they do not work average is fine.

May somebody help me?

Upvotes: 0

Views: 113

Answers (1)

ashumeow
ashumeow

Reputation: 151

I have tried it. Hope you find it useful.

SELECT NTH(50, quantiles(bytesTotal)) MedianBytesTotal
FROM [httparchive:runs.2010_12_28_pages], [httparchive:runs.2012_12_15_pages],
[httparchive:runs.2013_12_15_pages], [httparchive:runs.2014_12_15_pages];

I got the result as:- MedianBytesTotal -- 1074357

Upvotes: 1

Related Questions