What happened to bigquery-public-data.hacker_news.full? 4 points by mic47 3y ago ↗ HN All HN stories were pushed to bigquery-public-data.hacker_news.full BigQuery table on daily basis, but since 1st July 2022, there are no updates.
[–] sp332 3y ago ↗ You might have better luck emailing the Contact link at the bottom of the page here, hn@ycombinator.com [–] mic47 3y ago ↗ Thanks. Did that.
[–] speedgoose 3y ago ↗ I may be related to both HN’s servers dying at almost the same time because all their SSDs had a firmware bug that crashed after about 40 000 hours. [–] rozenmd 3y ago ↗ Outage happened on July 8/9, might not be related
[–] zX41ZdbW 3y ago ↗ It's easy to download this data by yourself from HN API. Simple shell script and one day, and you have the full dataset:https://github.com/ClickHouse/ClickHouse/issues/29693 [–] mic47 3y ago ↗ I already run queries against this dataset on weekly basis . If this is bug I prefer it to be fixed over engineering resource intensive workaround it.
[–] mic47 3y ago ↗ I already run queries against this dataset on weekly basis . If this is bug I prefer it to be fixed over engineering resource intensive workaround it.
6 comments
[ 1.4 ms ] story [ 94.5 ms ] threadhttps://github.com/ClickHouse/ClickHouse/issues/29693