3 ms·
This will save your time: https://play.clickhouse.com/play?user=play#U0VMRUNUIHRvcExldmVsRG9tYWluKHVybCkgQVMgZG9tYWluLCBjb3VudCgpIEFTIGMsIHN1bShzY29yZSksIHVuaX
by zX41ZdbW 4y ago
This will save your time:
https://play.clickhouse.com/play?user=play#U0VMRUNUIHRvcExldmVsRG9tYWluKHVybCkgQVMgZG9tYWluLCBjb3VudCgpIEFTIGMsIHN1bShzY29yZSksIHVuaXEoYnkpLCByb3VuZChhdmcoc2NvcmUpLCAzKSBGUk9NIGhhY2tlcm5ld3MgV0hFUkUgdHlwZSA9ICdzdG9yeScgQU5EIGRvbWFpbiAhPSAnJyBHUk9VUCBCWSAxIE9SREVSIEJZIDIgREVTQw== https://play.clickhouse.com/play?user=play#U0VMRUNUIHRvcExld...
Takeaways:
- .org is 50% better than .com;
- .edu and .gov are really nice;
- .io is cool, and much better than .uk;
PS. I don't remember any rate limits of the API. Here is how I downloaded the data: https://github.com/ClickHouse/ClickHouse/issues/29693 https://github.com/ClickHouse/ClickHouse/issues/29693
- tylerhannan 4y agoThanks zX41zdbW - I find the query you shared easier to reason about than: https://github.com/klausbreyer/hackernewsstats/blob/main/queries/count-years.sql https://github.com/klausbreyer/hackernewsstats/blob/main/que... Also: "Elapsed: 0.140 sec, read 33.95 million rows, 1.26 GB." 140 ms is quite impressive.
- return_to_monke 4y agoto be fair, that is large part because CH seems to have a topLevelDomain function
- deleted 4y ago[deleted]