asterixdb/asterix-app/src/test/resources/optimizerts/results/subquery/not_exists_ps.plan

-- DISTRIBUTE_RESULT  |PARTITIONED|
  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
    -- STREAM_PROJECT  |PARTITIONED|
      -- ASSIGN  |PARTITIONED|
        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
          -- STABLE_SORT [$$cntrycode(ASC)]  |PARTITIONED|
            -- RANGE_PARTITION_EXCHANGE [$$cntrycode(ASC)]  |PARTITIONED|
              -- FORWARD  |PARTITIONED|
                -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                  -- REPLICATE  |PARTITIONED|
                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                      -- SORT_GROUP_BY[$$189]  |PARTITIONED|
                              {
                                -- AGGREGATE  |LOCAL|
                                  -- NESTED_TUPLE_SOURCE  |LOCAL|
                              }
                        -- HASH_PARTITION_EXCHANGE [$$189]  |PARTITIONED|
                          -- SORT_GROUP_BY[$$163]  |PARTITIONED|
                                  {
                                    -- AGGREGATE  |LOCAL|
                                      -- NESTED_TUPLE_SOURCE  |LOCAL|
                                  }
                            -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                              -- STREAM_PROJECT  |PARTITIONED|
                                -- ASSIGN  |PARTITIONED|
                                  -- STREAM_PROJECT  |PARTITIONED|
                                    -- STREAM_SELECT  |PARTITIONED|
                                      -- STREAM_PROJECT  |PARTITIONED|
                                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                          -- SORT_GROUP_BY[$$186]  |PARTITIONED|
                                                  {
                                                    -- AGGREGATE  |LOCAL|
                                                      -- NESTED_TUPLE_SOURCE  |LOCAL|
                                                  }
                                            -- HASH_PARTITION_EXCHANGE [$$186]  |PARTITIONED|
                                              -- PRE_CLUSTERED_GROUP_BY[$$180]  |PARTITIONED|
                                                      {
                                                        -- AGGREGATE  |LOCAL|
                                                          -- STREAM_SELECT  |LOCAL|
                                                            -- NESTED_TUPLE_SOURCE  |LOCAL|
                                                      }
                                                -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                  -- STABLE_SORT [$$180(ASC)]  |PARTITIONED|
                                                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                      -- STREAM_PROJECT  |PARTITIONED|
                                                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                          -- HYBRID_HASH_JOIN [$$175][$$172]  |PARTITIONED|
                                                            -- HASH_PARTITION_EXCHANGE [$$175]  |PARTITIONED|
                                                              -- ASSIGN  |PARTITIONED|
                                                                -- STREAM_PROJECT  |PARTITIONED|
                                                                  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                    -- NESTED_LOOP  |PARTITIONED|
                                                                      -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                        -- ASSIGN  |PARTITIONED|
                                                                          -- STREAM_PROJECT  |PARTITIONED|
                                                                            -- ASSIGN  |PARTITIONED|
                                                                              -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                                -- DATASOURCE_SCAN (test.Customer)  |PARTITIONED|
                                                                                  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                                    -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
                                                                      -- BROADCAST_EXCHANGE  |PARTITIONED|
                                                                        -- STREAM_PROJECT  |UNPARTITIONED|
                                                                          -- ASSIGN  |UNPARTITIONED|
                                                                            -- AGGREGATE  |UNPARTITIONED|
                                                                              -- AGGREGATE  |UNPARTITIONED|
                                                                                -- RANDOM_MERGE_EXCHANGE  |PARTITIONED|
                                                                                  -- AGGREGATE  |PARTITIONED|
                                                                                    -- STREAM_SELECT  |PARTITIONED|
                                                                                      -- STREAM_PROJECT  |PARTITIONED|
                                                                                        -- ASSIGN  |PARTITIONED|
                                                                                          -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                                            -- DATASOURCE_SCAN (test.Customer)  |PARTITIONED|
                                                                                              -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                                                -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
                                                            -- HASH_PARTITION_EXCHANGE [$$172]  |PARTITIONED|
                                                              -- ASSIGN  |PARTITIONED|
                                                                -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                  -- DATASOURCE_SCAN (test.Orders)  |PARTITIONED|
                                                                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                      -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
                -- BROADCAST_EXCHANGE  |PARTITIONED|
                  -- AGGREGATE  |UNPARTITIONED|
                    -- RANDOM_MERGE_EXCHANGE  |PARTITIONED|
                      -- AGGREGATE  |PARTITIONED|
                        -- STREAM_PROJECT  |PARTITIONED|
                          -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                            -- REPLICATE  |PARTITIONED|
                              -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                -- SORT_GROUP_BY[$$189]  |PARTITIONED|
                                        {
                                          -- AGGREGATE  |LOCAL|
                                            -- NESTED_TUPLE_SOURCE  |LOCAL|
                                        }
                                  -- HASH_PARTITION_EXCHANGE [$$189]  |PARTITIONED|
                                    -- SORT_GROUP_BY[$$163]  |PARTITIONED|
                                            {
                                              -- AGGREGATE  |LOCAL|
                                                -- NESTED_TUPLE_SOURCE  |LOCAL|
                                            }
                                      -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                        -- STREAM_PROJECT  |PARTITIONED|
                                          -- ASSIGN  |PARTITIONED|
                                            -- STREAM_PROJECT  |PARTITIONED|
                                              -- STREAM_SELECT  |PARTITIONED|
                                                -- STREAM_PROJECT  |PARTITIONED|
                                                  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                    -- SORT_GROUP_BY[$$186]  |PARTITIONED|
                                                            {
                                                              -- AGGREGATE  |LOCAL|
                                                                -- NESTED_TUPLE_SOURCE  |LOCAL|
                                                            }
                                                      -- HASH_PARTITION_EXCHANGE [$$186]  |PARTITIONED|
                                                        -- PRE_CLUSTERED_GROUP_BY[$$180]  |PARTITIONED|
                                                                {
                                                                  -- AGGREGATE  |LOCAL|
                                                                    -- STREAM_SELECT  |LOCAL|
                                                                      -- NESTED_TUPLE_SOURCE  |LOCAL|
                                                                }
                                                          -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                            -- STABLE_SORT [$$180(ASC)]  |PARTITIONED|
                                                              -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                -- STREAM_PROJECT  |PARTITIONED|
                                                                  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                    -- HYBRID_HASH_JOIN [$$175][$$172]  |PARTITIONED|
                                                                      -- HASH_PARTITION_EXCHANGE [$$175]  |PARTITIONED|
                                                                        -- ASSIGN  |PARTITIONED|
                                                                          -- STREAM_PROJECT  |PARTITIONED|
                                                                            -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                              -- NESTED_LOOP  |PARTITIONED|
                                                                                -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                                  -- ASSIGN  |PARTITIONED|
                                                                                    -- STREAM_PROJECT  |PARTITIONED|
                                                                                      -- ASSIGN  |PARTITIONED|
                                                                                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                                          -- DATASOURCE_SCAN (test.Customer)  |PARTITIONED|
                                                                                            -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                                              -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
                                                                                -- BROADCAST_EXCHANGE  |PARTITIONED|
                                                                                  -- STREAM_PROJECT  |UNPARTITIONED|
                                                                                    -- ASSIGN  |UNPARTITIONED|
                                                                                      -- AGGREGATE  |UNPARTITIONED|
                                                                                        -- AGGREGATE  |UNPARTITIONED|
                                                                                          -- RANDOM_MERGE_EXCHANGE  |PARTITIONED|
                                                                                            -- AGGREGATE  |PARTITIONED|
                                                                                              -- STREAM_SELECT  |PARTITIONED|
                                                                                                -- STREAM_PROJECT  |PARTITIONED|
                                                                                                  -- ASSIGN  |PARTITIONED|
                                                                                                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                                                      -- DATASOURCE_SCAN (test.Customer)  |PARTITIONED|
                                                                                                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                                                          -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
                                                                      -- HASH_PARTITION_EXCHANGE [$$172]  |PARTITIONED|
                                                                        -- ASSIGN  |PARTITIONED|
                                                                          -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                            -- DATASOURCE_SCAN (test.Orders)  |PARTITIONED|
                                                                              -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                                -- EMPTY_TUPLE_SOURCE  |PARTITIONED|