You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/09/13 13:45:41 UTC
[GitHub] [incubator-doris] morningman opened a new issue #6640: [Bug] Can not hit rollup when using subquery.
morningman opened a new issue #6640:
URL: https://github.com/apache/incubator-doris/issues/6640
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
Palo 0.14.13
### What's Wrong?
```
select equipment_number,package_date, max(package_time) package_time from c_original_data_t group by equi
pment_number,package_date
```
can hit rollup, but the following sql can't:
```
explain select count(package_date) from (select equipment_number,package_date, max(package_time) package_time from c_original_data_t group by equi
pment_number,package_date) a group by package_date;
```
### What You Expected?
the 2 sql can both hit rollup.
### How to Reproduce?
_No response_
### Anything Else?
```
CREATE TABLE c_original_data_t
(
`package_time` bigint ,
`package_date` int ,
`equipment_number` VARCHAR(64) ,
`receive_time` bigint ,
`ip` VARCHAR(128) DEFAULT '',
`data` VARCHAR(10000) DEFAULT ''
)
ENGINE=olap
DUPLICATE KEY(package_time, package_date,equipment_number,receive_time)
DISTRIBUTED BY HASH(`equipment_number`) BUCKETS 32
PROPERTIES(
"replication_num" = "2"
);
create materialized view mv_c_original_data_t1 as select equipment_number,package_date, max(package_time) from c_original_data_t group by equipment_number,package_date;
```
### 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
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
[GitHub] [incubator-doris] SinyoWong commented on issue #6640: [Bug] Can not hit rollup when using subquery.
Posted by GitBox <gi...@apache.org>.
SinyoWong commented on issue #6640:
URL: https://github.com/apache/incubator-doris/issues/6640#issuecomment-1082823414
@morningman @yiguolei
--
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
[GitHub] [incubator-doris] SinyoWong commented on issue #6640: [Bug] Can not hit rollup when using subquery.
Posted by GitBox <gi...@apache.org>.
SinyoWong commented on issue #6640:
URL: https://github.com/apache/incubator-doris/issues/6640#issuecomment-1082809091
same problem!
--
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