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

4 pointsmic473y ago6 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.

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

4 pointsmic473y ago6 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.

6 comments

6 comments · 3 top-level

sp3323y ago· 1 in thread

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

mic47OP3y ago

Thanks. Did that.

zX41ZdbW3y ago· 1 in thread

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

mic47OP3y 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.

speedgoose3y ago· 1 in thread

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.

rozenmd3y ago

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

j / k navigate · click thread line to collapse

6 comments

6 comments · 3 top-level

sp3323y ago· 1 in thread

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

mic47OP3y ago

Thanks. Did that.

zX41ZdbW3y ago· 1 in thread

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

mic47OP3y 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.

speedgoose3y ago· 1 in thread

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.

rozenmd3y ago

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

j / k navigate · click thread line to collapse