1. 11
  1. 1

    Why materialize the zoom level constant in geoToH3?

    1. 1

      So it doesn’t need to be re-computed. In the ClickHouse example, 3 zoom levels are added in 70 seconds. They can now be aggregated in SELECT statements that should last for milliseconds.

      H3 is new and few datasets will include it, let alone at the Zoom levels your application might be interested in.

      1. 1

        Sorry, I meant why call materialize(7) inside geoToH3 to prevent ClickHouse evaluating 7 as a constant for that expression?

        1. 2

          When I first started working with H3s in ClickHouse there was an issue that was worked around by using the materialize call https://github.com/ClickHouse/ClickHouse/issues/35670