I'm not sure how much of the underlying Clickhouse feature set is available, but the Clickhouse documentation about index types is thorough and informative.

https://clickhouse.com/docs/en/optimize/sparse-primary-index...