[I] [Bug] when enable_nereids_planner=true,explain sql not use materialized view [doris]

["liujunfei2230 (via GitHub)" <gi...@apache.org>]

liujunfei2230 opened a new issue, #27032:
URL: https://github.com/apache/doris/issues/27032

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
   
   
   ### Version
   
   2.0.2
   
   ### What's Wrong?
   
   when set enable_nereids_planner=true,  explain sql not use mv;
   when  set enable_nereids_planner=false, explain sql use mv, but another exception accured. with condition and count  sql raise an unknown exception.
   
   ### What You Expected?
   
   when set enable_nereids_planner=true,  explain sql would use mv;
   
   ### How to Reproduce?
   
   case:
   sql1：
   EXPLAIN
   sELECT * FROM dispatch_call_log_tmp
   WHERE  call_uuid='aaaaga';
   
   sql2：
   EXPLAIN
   sELECT count(1) FROM dispatch_call_log_tmp
   WHERE  call_uuid='aaaaga';
   
   sql3：
   create  materialized view mv_1 as select call_uuid,org_id,call_time,id,campaign_id,answered_time,hangup_time,... from dispatch_call_log_tmp
   
   sql4：
   create table bi.dispatch_call_log(
   org_id  bigint,
   campaign_id bigint,
   call_time   datetime,
   id  bigint,
   call_uuid   varchar(128),
   ...
   )
   unique KEY(org_id,campaign_id,call_time,id,call_uuid)
   PARTITION BY RANGE(call_time)()
   DISTRIBUTED BY HASH(id) BUCKETS 1
   PROPERTIES
   (
       "dynamic_partition.enable" = "true",
       "dynamic_partition.time_unit" = "day",
       "dynamic_partition.start" = "-186",
       "dynamic_partition.end" = "1",
       "dynamic_partition.prefix" = "d",
       "dynamic_partition.buckets" = "1",
       "dynamic_partition.create_history_partition" = "true",
       "dynamic_partition.history_partition_num" = "186",
       "bloom_filter_columns"="callee,call_uuid",
       "replication_num" = "3"
   );
   
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

Re: [I] [Bug] when enable_nereids_planner=true,explain sql not use materialized view [doris]

["morrySnow (via GitHub)" <gi...@apache.org>]

morrySnow closed issue #27032: [Bug] when enable_nereids_planner=true,explain sql  not use materialized view
URL: https://github.com/apache/doris/issues/27032


-- 
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-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org