Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
Description
There are certain cases where expressions has conditions which needs to be applied for each resultant row. For eg. sum(case when city_dim.city_name = 'abc' then total_count when city_dim.city_name is null then 0 end) . Columnar rewriter is rewriting such expression as fact subquery and passing the result to main query. We should skip such rewrite and do it only once in the main query.