6 ms·

What happened to bigquery-public-data.hacker_news.full?

4 points by mic47 4y ago

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.

speedgoose 4y 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 4y ago
  Outage happened on July 8/9, might not be related
sp332 4y ago
You might have better luck emailing the Contact link at the bottom of the page here, hn@ycombinator.com
- mic47 4y ago
  Thanks. Did that.
zX41ZdbW 4y 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 https://github.com/ClickHouse/ClickHouse/issues/29693
- mic47 4y 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.