| N0 |
| SELECT * FROM ct1_n1, ct2_n1 |
| --- |
| Fragment#0 root |
| distribution: single |
| executionNodes: [N0] |
| exchangeSourceNodes: {3=[N1]} |
| tree: |
| Receiver |
| fieldNames: [ID0, C10, C20, ID, C1, C2] |
| sourceFragmentId: 3 |
| est: (rows=1) |
| |
| Fragment#3 |
| distribution: single |
| executionNodes: [N1] |
| targetNodes: [N0] |
| partitions: [CT1_N1=[N1={0}], CT2_N1=[N1={0}]] |
| tree: |
| Sender |
| distribution: single |
| targetFragmentId: 0 |
| est: (rows=10000300002) |
| Project |
| fieldNames: [ID0, C10, C20, ID, C1, C2] |
| projection: [ID$0, C1$0, C2$0, ID, C1, C2] |
| est: (rows=10000300002) |
| NestedLoopJoin |
| predicate: true |
| fieldNames: [ID, C1, C2, ID$0, C1$0, C2$0] |
| type: inner |
| est: (rows=10000300002) |
| TableScan |
| table: PUBLIC.CT2_N1 |
| fieldNames: [ID, C1, C2] |
| est: (rows=100002) |
| TableScan |
| table: PUBLIC.CT1_N1 |
| fieldNames: [ID, C1, C2] |
| est: (rows=100001) |
| --- |
| |
| N1 |
| SELECT * FROM ct1_n1, ct2_n1 |
| --- |
| Fragment#0 root |
| distribution: single |
| executionNodes: [N1] |
| partitions: [CT1_N1=[N1={0}], CT2_N1=[N1={0}]] |
| tree: |
| Project |
| fieldNames: [ID0, C10, C20, ID, C1, C2] |
| projection: [ID$0, C1$0, C2$0, ID, C1, C2] |
| est: (rows=10000300002) |
| NestedLoopJoin |
| predicate: true |
| fieldNames: [ID, C1, C2, ID$0, C1$0, C2$0] |
| type: inner |
| est: (rows=10000300002) |
| TableScan |
| table: PUBLIC.CT2_N1 |
| fieldNames: [ID, C1, C2] |
| est: (rows=100002) |
| TableScan |
| table: PUBLIC.CT1_N1 |
| fieldNames: [ID, C1, C2] |
| est: (rows=100001) |
| --- |
| |
| N0 |
| SELECT * FROM ct1_n1, ct2_n2 |
| --- |
| Fragment#0 root |
| distribution: single |
| executionNodes: [N0] |
| exchangeSourceNodes: {4=[N2]} |
| tree: |
| Receiver |
| fieldNames: [ID0, C10, C20, ID, C1, C2] |
| sourceFragmentId: 4 |
| est: (rows=1) |
| |
| Fragment#4 |
| distribution: single |
| executionNodes: [N2] |
| targetNodes: [N0] |
| exchangeSourceNodes: {3=[N1]} |
| partitions: [CT2_N2=[N2={0}]] |
| tree: |
| Sender |
| distribution: single |
| targetFragmentId: 0 |
| est: (rows=100003) |
| Project |
| fieldNames: [ID0, C10, C20, ID, C1, C2] |
| projection: [ID$0, C1$0, C2$0, ID, C1, C2] |
| est: (rows=100003) |
| NestedLoopJoin |
| predicate: true |
| fieldNames: [ID, C1, C2, ID$0, C1$0, C2$0] |
| type: inner |
| est: (rows=100003) |
| TableScan |
| table: PUBLIC.CT2_N2 |
| fieldNames: [ID, C1, C2] |
| est: (rows=100003) |
| Receiver |
| fieldNames: [ID, C1, C2] |
| sourceFragmentId: 3 |
| est: (rows=1) |
| |
| Fragment#3 |
| distribution: single |
| executionNodes: [N1] |
| targetNodes: [N2] |
| partitions: [CT1_N1=[N1={0}]] |
| tree: |
| Sender |
| distribution: single |
| targetFragmentId: 4 |
| est: (rows=100001) |
| TableScan |
| table: PUBLIC.CT1_N1 |
| fieldNames: [ID, C1, C2] |
| est: (rows=100001) |
| --- |
| |
| N1 |
| SELECT * FROM ct1_n1, ct2_n2 |
| --- |
| Fragment#0 root |
| distribution: single |
| executionNodes: [N1] |
| exchangeSourceNodes: {4=[N2]} |
| tree: |
| Receiver |
| fieldNames: [ID0, C10, C20, ID, C1, C2] |
| sourceFragmentId: 4 |
| est: (rows=1) |
| |
| Fragment#4 |
| distribution: single |
| executionNodes: [N2] |
| targetNodes: [N1] |
| exchangeSourceNodes: {3=[N1]} |
| partitions: [CT2_N2=[N2={0}]] |
| tree: |
| Sender |
| distribution: single |
| targetFragmentId: 0 |
| est: (rows=100003) |
| Project |
| fieldNames: [ID0, C10, C20, ID, C1, C2] |
| projection: [ID$0, C1$0, C2$0, ID, C1, C2] |
| est: (rows=100003) |
| NestedLoopJoin |
| predicate: true |
| fieldNames: [ID, C1, C2, ID$0, C1$0, C2$0] |
| type: inner |
| est: (rows=100003) |
| TableScan |
| table: PUBLIC.CT2_N2 |
| fieldNames: [ID, C1, C2] |
| est: (rows=100003) |
| Receiver |
| fieldNames: [ID, C1, C2] |
| sourceFragmentId: 3 |
| est: (rows=1) |
| |
| Fragment#3 |
| distribution: single |
| executionNodes: [N1] |
| targetNodes: [N2] |
| partitions: [CT1_N1=[N1={0}]] |
| tree: |
| Sender |
| distribution: single |
| targetFragmentId: 4 |
| est: (rows=100001) |
| TableScan |
| table: PUBLIC.CT1_N1 |
| fieldNames: [ID, C1, C2] |
| est: (rows=100001) |
| --- |
