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

Posted by mic47 on Saturday July 16, 2022 @12:05PM
from the self-post dept.

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.

( 6 comments | 4 points | on HN )

Re:What happened to bigquery-public-data.hacker_news.full? by sp332 on Saturday July 16, 2022 @12:37PM (#32119642)

You might have better luck emailing the Contact link at the bottom of the page here, [email protected]

[ Parent | on HN ]

Re:What happened to bigquery-public-data.hacker_news.full? by mic47 on Saturday July 16, 2022 @06:32PM (#32122557)

Thanks. Did that.

[ Parent | on HN ]

Re:What happened to bigquery-public-data.hacker_news.full? by zX41ZdbW on Saturday July 16, 2022 @03:54PM (#32121369)

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

[ Parent | on HN ]

Re:What happened to bigquery-public-data.hacker_news.full? by mic47 on Saturday July 16, 2022 @06:32PM (#32122552)

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.

[ Parent | on HN ]

Re:What happened to bigquery-public-data.hacker_news.full? by speedgoose on Saturday July 16, 2022 @12:47PM (#32119751)

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.

[ Parent | on HN ]

Re:What happened to bigquery-public-data.hacker_news.full? by rozenmd on Saturday July 16, 2022 @02:36PM (#32120670)

Outage happened on July 8/9, might not be related

[ Parent | on HN ]