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 2020/03/30 12:29:30 UTC
[GitHub] [incubator-doris] kangkaisen opened a new issue #3231: Support
rewrite count distinct bitmap and hll column in order by and having clause
kangkaisen opened a new issue #3231: Support rewrite count distinct bitmap and hll column in order by and having clause
URL: https://github.com/apache/incubator-doris/issues/3231
**Describe the bug**
```
CREATE TABLE test.bitmap_table (\n" +
" `id` int(11) NULL COMMENT \"\",\n" +
" `id2` bitmap bitmap_union NULL\n" +
") ENGINE=OLAP\n" +
"AGGREGATE KEY(`id`)\n" +
"DISTRIBUTED BY HASH(`id`) BUCKETS 1\n" +
"PROPERTIES (\n" +
" \"replication_num\" = \"1\"\n" +
");"
```
When query
```
select count(distinct id2) from test.bitmap_table having count(distinct id2) > 0
select count(distinct id2) from test.bitmap_table order by count(distinct id2) > 0
```
We will get the following error:
```
Doris hll and bitmap column must use with specific function, and don't support filter or group by." +
"please run 'help hll' or 'help bitmap' in your mysql client.
```
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] imay closed issue #3231: Support rewrite count
distinct bitmap and hll column in order by and having clause
Posted by GitBox <gi...@apache.org>.
imay closed issue #3231: Support rewrite count distinct bitmap and hll column in order by and having clause
URL: https://github.com/apache/incubator-doris/issues/3231
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org