EmeraldShift commented on issue #15177: URL: https://github.com/apache/datafusion/issues/15177#issuecomment-2840412850
> They are currently exploring the possibility of using it alongside projections (a feature in ClickHouse akin to materialized views) to create secondary indexes and similar functionalities. Relevant PR: https://github.com/ClickHouse/ClickHouse/pull/78429#issuecomment-2777130157. There's a follow-up PR that makes the query in that comment work consistently: https://github.com/ClickHouse/ClickHouse/pull/79471 Also, I had asked for something that sounds equivalent to dynamic filter in TopK in ClickHouse in https://github.com/ClickHouse/ClickHouse/issues/75098 and https://github.com/ClickHouse/ClickHouse/issues/75774#issuecomment-2656469210, so it seems like CH has yet to perform that optimization at the moment, it just has lazy materialization and soon the manual version of it via query rewriting and "projection indexes". -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org