Posted by
xuchuanyin on
Sep 26, 2018; 1:09am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Issue-Bloomfilter-datamap-tp63254p63485.html
Did you use the query in the first post? I tested it and it's OK, we can see
the bloomfilter while explaining.
1. If bloomfilter is not there, the reason may be that the main datamap has
already pruned all the blocklets. In this case, the following index datamap
will be skipped for shortcut. Often, the query will be empty.
2. Or your query hit the preagg datamap and it will not use index datamap
for that query, because the query plan has already been rewritten for
querying preagg.
Can you post the explaining result if you still have problems.
Ps: the data I used for testing:
```
INSERT INTO store VALUES
("market_code_str", "device_code_str", "country_code_str", 100000,
590416100, "2016-08-01 12:00:00", 101, 1001, 10001),
("market_code_str", "ios-phone", "CC", 100000, 590416100, "2016-09-02
12:00:00", 101, 1001, 10001),
("market_code_str", "ios-phone", "EE", 100001, 590416158, "2016-09-02
12:00:00", 101, 1001, 10001),
("market_code_str", "ios-phone", "EE", 100021, 590416158, "2016-09-02
12:00:00", 101, 1001, 10001),
("market_code_str", "ios-phone", "FF", 100031, 590437560, "2016-09-02
12:00:00", 101, 1001, 10001),
("market_code_str", "ios-phone", "EE", 100021, 590437560, "2016-09-02
12:00:00", 101, 1001, 10001);
```
This data will always make the mentioned query hit the blocklet in default
blocklet datamap, so it will comes to bloom datamap.
--
Sent from:
http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/