It makes many requests in parallel, and that's why some of them could be retried. It logs every retry, e.g., "Failed at try 3/10". It will throw an error only if it fails all ten tries. The number of retries is defined in the script.
Example of how it should work:
$ ch -q "SELECT * FROM url('https://hacker-news.firebaseio.com/v0/item/40298680.json')" --format Vertical
Row 1:
──────
by: octopoc
id: 40298680
parent: 40297716
text: Oops, thanks. I guess Marx was being referenced? I had thought Marx was English but apparently he was German-Jewish[1]<p>[1] <a href="https://en.wikipedia.org/wiki/Karl_Marx" rel="nofollow">https://en.wikipedia.org/wiki/Karl_Marx</a>
time: 1715179584
type: comment
