Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
PLAN FRAGMENT 0
OUTPUT EXPRS:7: country | 4: status | 11: count
PARTITION: UNPARTITIONED
RESULT SINK
12:EXCHANGE
PLAN FRAGMENT 1
OUTPUT EXPRS:
PARTITION: HASH_PARTITIONED: 7: country, 4: status
STREAM DATA SINK
EXCHANGE ID: 12
UNPARTITIONED
11:AGGREGATE (merge finalize)
| output: count(11: count)
| group by: 7: country, 4: status
|
10:EXCHANGE
PLAN FRAGMENT 2
OUTPUT EXPRS:
colocate exec groups: ExecGroup{groupId=1, nodeIds=[0, 7, 8, 9]}
PARTITION: RANDOM
STREAM DATA SINK
EXCHANGE ID: 10
HASH_PARTITIONED: 7: country, 4: status
9:AGGREGATE (update serialize)
| STREAMING
| output: count(*)
| group by: 7: country, 4: status
|
8:Project
| <slot 4> : 4: status
| <slot 7> : 7: country
|
7:HASH JOIN
| join op: INNER JOIN (BROADCAST)
| colocate: false, reason:
| equal join conjunct: 2: customer_id = 5: id
|
|----6:EXCHANGE
|
0:OlapScanNode
TABLE: orders
PREAGGREGATION: ON
PREDICATES: 2: customer_id IS NOT NULL
partitions=1/1
rollup: orders
tabletRatio=2/2
tabletList=10015,10017
cardinality=4500
avgRowSize=2.0
PLAN FRAGMENT 3
OUTPUT EXPRS:
colocate exec groups: ExecGroup{groupId=3, nodeIds=[1, 2, 3, 4, 5]}
PARTITION: RANDOM
STREAM DATA SINK
EXCHANGE ID: 06
UNPARTITIONED
5:Project
| <slot 5> : 5: id
| <slot 7> : 7: country
|
4:HASH JOIN
| join op: INNER JOIN (COLOCATE)
| colocate: true
| equal join conjunct: 5: id = 8: id
|
|----3:Project
| | <slot 8> : 8: id
| |
| 2:OlapScanNode
| TABLE: customers
| PREAGGREGATION: ON
| PREDICATES: 8: id IS NOT NULL, 10: country = 'JP'
| partitions=1/1
| rollup: customers
| tabletRatio=2/2
| tabletList=10007,10009
| cardinality=450
| avgRowSize=2.0
|
1:OlapScanNode
TABLE: customers
PREAGGREGATION: ON
PREDICATES: 5: id IS NOT NULL
partitions=1/1
rollup: customers
tabletRatio=2/2
tabletList=10007,10009
cardinality=450
avgRowSize=2.0