zeropc commented on issue #6009: URL: https://github.com/apache/incubator-doris/issues/6009#issuecomment-861266893
> Can you supply a user case which may cause this bug? > I want to reproduce it . 1. create a table without partition but only distributed like below: create table `blabla` (`date` date NULL COMMENT "distribute key", `total_num` bigint(20) SUM NULL COMMENT "sum") ENGINE=OLAP AGGREGATE KEY(`date`) COMMENT "OLAP" DISTRIBUTED BY HASH(`date`) BUCKETS 12; 2. use spark load to insert data with `date` valued '2021-06-07' 3. see the result of below queries: select count(1) from `blabla` where `date` = '2021-06-07' (got 0, which is not expected) select count(1) from `blabla` where `date` >= '2021-06-07' (correct) if we check the plan with "explain select count(1) from `blabla` where `date` = '2021-06-07'", we will see that the scanned tablet is not the same with the one computed by spark load. -- 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. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
