Public signup for this instance is disabled. Our Jira Guidelines page explains how to get an account.
Share this issue
Enlightened by HIVE-11684 (Kudos to Jesus Camacho Rodriguez), we can actually push limit down through union all, which reduces the intermediate number of rows in union branches.
Rules to push down limits
Implement limit pushdown through outer join in CBO