One billion row challenge in ClickHouse SQL

Author of the post here, would love to hear ideas for optimization to improve this.