| N1 |
| SELECT /*+ DISABLE_RULE('MapReduceMinusConverterRule')*/ * FROM (SELECT c2 FROM t1_n1 EXCEPT SELECT c2 FROM t2_n2) |
| --- |
| Fragment#0 root |
| distribution: single |
| executionNodes: [N1] |
| exchangeSourceNodes: {1=[N1], 2=[N2]} |
| tree: |
| ColocatedMinus |
| all: false |
| est: (rows=1) |
| Receiver |
| fieldNames: [C2] |
| sourceFragmentId: 1 |
| est: (rows=1) |
| Receiver |
| fieldNames: [C2] |
| sourceFragmentId: 2 |
| est: (rows=1) |
| |
| Fragment#1 |
| distribution: random |
| executionNodes: [N1] |
| targetNodes: [N1] |
| partitions: [T1_N1=[N1={0}]] |
| tree: |
| Sender |
| distribution: single |
| targetFragmentId: 0 |
| est: (rows=100001) |
| TableScan |
| table: PUBLIC.T1_N1 |
| fieldNames: [C2] |
| est: (rows=100001) |
| |
| Fragment#2 |
| distribution: random |
| executionNodes: [N2] |
| targetNodes: [N1] |
| partitions: [T2_N2=[N2={0}]] |
| tree: |
| Sender |
| distribution: single |
| targetFragmentId: 0 |
| est: (rows=100002) |
| TableScan |
| table: PUBLIC.T2_N2 |
| fieldNames: [C2] |
| est: (rows=100002) |
| --- |
| |
| N1 |
| SELECT /*+ DISABLE_RULE('ColocatedMinusConverterRule')*/ * FROM (SELECT c2 FROM t1_n1 EXCEPT SELECT c2 FROM t2_n2) |
| --- |
| Fragment#0 root |
| distribution: single |
| executionNodes: [N1] |
| exchangeSourceNodes: {1=[N1, N2]} |
| tree: |
| ReduceMinus |
| all: false |
| est: (rows=1) |
| Receiver |
| fieldNames: [f0, _COUNT_0, _COUNT_1] |
| sourceFragmentId: 1 |
| est: (rows=1) |
| |
| Fragment#1 |
| distribution: random |
| executionNodes: [N1, N2] |
| targetNodes: [N1] |
| partitions: [T1_N1=[N1={0}], T2_N2=[N2={0}]] |
| tree: |
| Sender |
| distribution: single |
| targetFragmentId: 0 |
| est: (rows=50001) |
| MapMinus |
| all: false |
| est: (rows=50001) |
| TableScan |
| table: PUBLIC.T1_N1 |
| fieldNames: [C2] |
| est: (rows=100001) |
| TableScan |
| table: PUBLIC.T2_N2 |
| fieldNames: [C2] |
| est: (rows=100002) |
| --- |
