maheshk114 commented on PR #41860:
URL: https://github.com/apache/spark/pull/41860#issuecomment-1630402790
> This is so strange.
>
> ```
> select *
> from test_bloom.small_table a
> left outer join test_bloom.big_table b
> on a.number = b.pk;
> ```
>
> The SQL show above haven't any selective filter. So the runtime filter
really works ?
@beliefer You have to add a dummy filter to the query(where a.number > 0).
The open source version needs the extra filter for the bloom filter to be added.
select *
from test_bloom.small_table a
left outer join test_bloom.big_table b
on a.number = b.pk where a.number > 0;
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
