Describe the bug
Bucket shuffle join is a algorithm of joining two tables. Left table is distrubuted by a column. Right table sends the data to the left table for joining operation. It reduces the network cost. But when two table is only true bucket num lower bucket seq. Bucket shuffle join will fail.
To Reproduce
- enable bucket shuffle join
set enable_bucket_shuffle_join=true
- execute a sql
select * from dynamic_partition2 a join dynamic_partition_bucket2 b on a.k2 = b.k2 where a.k1=20201218 ;
- see the error
