Earlier quoted context omitted.
May I hijack this thread for a related q. I love the public up-to-date hn dataset. I saw recursive cte blog post..but this doesn't seem to work your hn dataset https://play.clickhouse.com/play?user=play#V0lUSCBSRUNVUlNJV... Are recursive ctes disabled on this instance or am i doing something wrong?
Done, and now it works perfectly.
what was broken?