optimize_rewrite_aggregate_function_with_if
Rewrite aggregate functions with if expression as argument when logically equivalent. For example,avg(if(cond, col, null)) can be rewritten to avgOrNullIf(cond, col). It may improve performance.
Supported only with the analyzer (
enable_analyzer = 1).optimize_rewrite_array_exists_to_has
Rewrite arrayExists() functions to has() when logically equivalent. For example, arrayExists(x -> x = 1, arr) can be rewritten to has(arr, 1)optimize_rewrite_has_to_in
Rewritehas functions to IN when the first argument is a constant array. For example, has([1, 2, 3], x) can be rewritten to x IN [1, 2, 3] for better performance with constant arrays
optimize_rewrite_like_perfect_affix
Rewrite LIKE expressions with perfect prefix or suffix (e.g.col LIKE 'ClickHouse%') to startsWith or endsWith functions (e.g. startsWith(col, 'ClickHouse')).