BROADCAST_BYTES_LIMIT Query Option
Sets the limit for the size of the broadcast input based on estimated size.
The Impala planner may in rare cases make a bad choice to broadcast a large table or intermediate result and encounter performance problems due to high memory pressure. Setting this limit will make the planner pick a partition based hash join instead of broadcast and avoid such performance problems.
The default value is 34359738368 (32 GB). A value of 0 causes the option to be ignored.
-- Change the limit to 16GB. set broadcast_bytes_limit=17179869184; -- Disable the BROADCAST_BYTES_LIMIT. set broadcast_bytes_limit=0;