3 ms·
I did a similar thing recently: https://twitter.com/tbragin/status/1749580473800556779 https://twitter.com/tbragin/status/1749580473800556779 And it is entirel
by zX41ZdbW 3y ago
I 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')