We are using Hive version (Apache Hive (version 22.214.171.124.1.0.0-78) and trying to implement Bloom filter in it. So basically I have created a managed table with table properties defined as:
'orc.bloom.filter.columns'='*******', 'orc.bloom.filter.fpp'='0.05', 'orc.stripe.size'='268435456',
and stored it as orc file. While checking the explain plan(running: explain select count(1) from the_table where <condition>) in the current Hive version, I couldn't see anything as "Bloom_Filter" in the Plan provided by the CBO. The table I'm querying data in has records.
I have a few doubts:
I have tried the same process creating a Hive external table as well and tried Bloom filter in it, but in vain.
This experiment for both managed as well as external table is has failed for Composite Bloom filter(used 3 columns), hence used a single field as Bloom filter.
Please let me know if anyone has used Bloom filter. Let me know then the process(please check explain plan once Bloom filter is used).
I hava the same issue with yours, can anybody answer this? Thans a lot