from Hacker News

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

by mic47 on 7/16/22, 4:05 PM with 6 comments

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.

  • by sp332 on 7/16/22, 4:37 PM

    You might have better luck emailing the Contact link at the bottom of the page here, hn@ycombinator.com

  • by zX41ZdbW on 7/16/22, 7:54 PM

    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

  • by speedgoose on 7/16/22, 4:47 PM

    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.