[GitHub] [incubator-doris] kangkaisen opened a new issue #3231: Support rewrite count distinct bitmap and hll column in order by and having clause

[GitBox]

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:
us...@infra.apache.org


With regards,
Apache Git Services

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