JackyYangPassion commented on issue #1610: Add bitmap agg type and udaf URL: https://github.com/apache/incubator-doris/pull/1610#issuecomment-571087060 > > I use mysql client with the bitmap doc, but there is error > > `Encountered: IDENTIFIER` > > create table sql : > > `CREATE TABLE `pv_bitmap`(`dt`int(11) NULL COMMENT "",`page`varchar(10) NULL COMMENT "",`user_id` bitmap BITMAP_UNION NULL COMMENT "" ) ENGINE=OLAP AGGREGATE KEY(`dt`, `page`) COMMENT "OLAP" DISTRIBUTED BY HASH(`dt`) BUCKETS 2;` > > if there need some set in client? > > Server version: 5.1.0 Doris version DORIS-0.11.14-release > > you can try > > ``` > `user_id` varchar(0) BITMAP_UNION NULL COMMENT "" > ``` when i create table with sql it works `CREATE TABLE `bitmap_test` ( `id` int(11) NULL COMMENT "", `id2` varchar(100) BITMAP_UNION NULL COMMENT "" ) ENGINE=OLAP AGGREGATE KEY(`id`) COMMENT "OLAP" DISTRIBUTED BY HASH(`id`) BUCKETS 10` but when insert value there is some error insert into bitmap_test values (10,bitmap_hash('a100')); `ERROR 1064 (HY000): No matching function with signature: bitmap_hash(varchar(-1)).`
---------------------------------------------------------------- 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] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
