3 ms·
How do you get the historical data?
by ecuaflo 3y ago
How do you get the historical data?
- zX41ZdbW 3y agoI did a similar thing recently: https://twitter.com/tbragin/status/1749580473800556779 https://twitter.com/tbragin/status/1749580473800556779 And it is entirely trivial: ITEMS=$(clickhouse-local --query "SELECT arrayStringConcat(items, ',') FROM url('https://hacker-news.firebaseio.com/v0/updates.json')") clickhouse-client --query " INSERT INTO hackernews_changes_items SELECT * FROM url('https://hacker-news.firebaseio.com/v0/item/{$ITEMS}.json')