compilation error for query containing multiple nested sub-queries

SELECT * 

FROM collection1 a1

WHERE (

    SELECT count(*) 

    FROM collection2 a2 

    WHERE a1.t=a2.t and a1.p=3 and (

       SELECT count(*) 

        FROM collection2 a3 

        WHERE a2.t1=a3.t1 and a2.p1=3 and (

            SELECT count(*) 

                FROM collection4 a4 

                WHERE a3.t2=a4.t2 and a3.p2=3 and (

                    SELECT count(*) 

                        FROM collection5 a5 

                        WHERE a4.t=a5.t and a4.p=3 and (

                        SELECT count(*) 

                            FROM collection6 a6 

                            WHERE a5.t1=a6.t1 and a5.p1=3 

                        ) > 12

                    ) > 10

                ) > 16

        ) > 14

    ) > 12;

10:07:52.964 [HttpExecutor(port:19001)-3] ERROR org.apache.asterix - Could not modify UNORDERED_PARTITIONED[$$586, $$587, $$588, $$589, $$590, $$591, $$592, $$593, $$594, $$595, $$596, $$597, $$598, $$599, $$600, $$601, $$602, $$603] domain:[asterix_nc1:2, asterix_nc2:2] to agree with partitioning property UNORDERED_PARTITIONED[$$472, $$473, $$474, $$475, $$476, $$477, $$478, $$479, $$480, $$481, $$482, $$483, $$363, $$361, $$392, $$398, $$391] domain:[asterix_nc1:2, asterix_nc2:2] delivered by previous input operator.

org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Could not modify UNORDERED_PARTITIONED[$$586, $$587, $$588, $$589, $$590, $$591, $$592, $$593, $$594, $$595, $$596, $$597, $$598, $$599, $$600, $$601, $$602, $$603] domain:[asterix_nc1:2, asterix_nc2:2] to agree with partitioning property UNORDERED_PARTITIONED[$$472, $$473, $$474, $$475, $$476, $$477, $$478, $$479, $$480, $$481, $$482, $$483, $$363, $$361, $$392, $$398, $$391] domain:[asterix_nc1:2, asterix_nc2:2] delivered by previous input operator.

    at org.apache.hyracks.algebricks.core.algebra.operators.physical.AbstractHashJoinPOperator$1.coordinateRequirements(AbstractHashJoinPOperator.java:181) ~[classes/:?]

    at org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:232) ~[classes/:?]

    at org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:191) ~[classes/:?]

    at org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:191) ~[classes/:?]

    at org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:191) ~[classes/:?]

    at org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:191) ~[classes/:?]

    at org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:191) ~[classes/:?]

    at org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:191) ~[classes/:?]

    at org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:191) ~[classes/:?]

    at org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:191) ~[classes/:?]

    at org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:191) ~[classes/:?]

    at org.apache.hyracks.algebricks.rewriter.rules.EnforceStructuralPropertiesRule.physOptimizeOp(EnforceStructuralPropertiesRule.java:191) ~[classes/:?]