BiteTheDDDDt commented on issue #9346: URL: https://github.com/apache/doris/issues/9346#issuecomment-1559087773
> Hello, to_bitmap(num_col) can be changed to bitmap_hash(num_col) in 2.0. As for why the case you listed is restricted, it is because the aggregation type of a certain column on the materialized view/rollup needs to be consistent with the base table. The mv with group by actually creates a corresponding agg table for the base table. For example, consider the following situations: The base table type is dup, with a value column k1 on it, and a materialized view with a sum column k1 can be created (the base table has no aggregation type). The base table type is agg, with sum column k1 on it, and a materialized view with sum column k1 can be created (the aggregation type is the same). The base table type is uniq, and there is a value column k1 on it. At this time, the aggregation type equivalent to k1 is replace, so the materialized view of k1 with the sum aggregation type cannot be created. (Different aggregation types) For specific reasons, you can understand the principle of the agg table, and think about what problems will exist if this restriction is not imposed. -- 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
