| N1 |
| SELECT /*+ DISABLE_RULE('MapReduceMinusConverterRule')*/ * FROM (SELECT c2 FROM t1_n1 EXCEPT SELECT c2 FROM t2_n2) |
| --- |
| Fragment#0 root |
| executionNodes: [N1] |
| remoteFragments: [1, 2] |
| exchangeSourceNodes: {1=[N1], 2=[N2]} |
| tree: |
| ColocatedMinus |
| Receiver(sourceFragment=1, exchange=1, distribution=single) |
| Receiver(sourceFragment=2, exchange=2, distribution=single) |
| |
| Fragment#2 |
| targetNodes: [N1] |
| executionNodes: [N2] |
| tables: [T2_N2] |
| partitions: {N2=[0:1]} |
| tree: |
| Sender(targetFragment=0, exchange=2, distribution=single) |
| TableScan(name=PUBLIC.T2_N2, source=3, partitions=1, distribution=random) |
| |
| Fragment#1 |
| targetNodes: [N1] |
| executionNodes: [N1] |
| tables: [T1_N1] |
| partitions: {N1=[0:1]} |
| tree: |
| Sender(targetFragment=0, exchange=1, distribution=single) |
| TableScan(name=PUBLIC.T1_N1, source=4, partitions=1, distribution=random) |
| --- |
| |
| N1 |
| SELECT /*+ DISABLE_RULE('ColocatedMinusConverterRule')*/ * FROM (SELECT c2 FROM t1_n1 EXCEPT SELECT c2 FROM t2_n2) |
| --- |
| Fragment#0 root |
| executionNodes: [N1] |
| remoteFragments: [1] |
| exchangeSourceNodes: {1=[N1, N2]} |
| tree: |
| ReduceMinus |
| Receiver(sourceFragment=1, exchange=1, distribution=single) |
| |
| Fragment#1 |
| targetNodes: [N1] |
| executionNodes: [N1, N2] |
| tables: [T1_N1, T2_N2] |
| partitions: {N1=[0:1], N2=[0:1]} |
| tree: |
| Sender(targetFragment=0, exchange=1, distribution=single) |
| MapMinus |
| TableScan(name=PUBLIC.T1_N1, source=2, partitions=1, distribution=random) |
| TableScan(name=PUBLIC.T2_N2, source=3, partitions=1, distribution=random) |
| --- |
