HIVE-27939: Many UNION ALL throws SemanticException when trying to remove partition predicates: fail to find child from parent

[ryukobayashi]

What changes were proposed in this pull request?

Complex queries with many UNIONs will fail with a SemanticException. So, this PR will be fix that issue.

Why are the changes needed?

Complex queries with many UNIONs will fail with a SemanticException.

Does this PR introduce any user-facing change?

No.

Is the change a dependency upgrade?

No.

How was this patch tested?

I ran the query I attached to the ticket on local machine.

[sonarqubecloud[bot]]

Quality Gate passed

The SonarCloud Quality Gate passed, but some issues were introduced.

9 New issues
0 Security Hotspots
No data about Coverage
No data about Duplication

See analysis details on SonarCloud

[ryukobayashi]

Since it no longer occurs by setting the hive.optimize.cte.materialize.full.aggregate.only property to false, we will close it for now.