starrocks profile 里的 join 的这个 jointype 怎么理解 : , 比如这里写RIGHT_OUTER_JOIN,哪一个表是右表呢,哪一个是左表
HASH_JOIN_BUILD (plan_node_id=3):
CommonMetrics:
- CloseTime: 7.93us
- OperatorTotalTime: 62.262ms
- PeakMemoryUsage: 0.00
- PrepareTime: 47.493us
- PullChunkNum: 0
- PullRowNum: 0
- PullTotalTime: 0ns
- PushChunkNum: 1
- PushRowNum: 3
- PushTotalTime: 10.8us
- RuntimeBloomFilterNum: 0
- RuntimeInFilterNum: 0
- SetFinishedTime: 24ns
- SetFinishingTime: 62.244ms
UniqueMetrics:
- JoinPredicates: 166: user_code = 7: user_code
- DistributionMode: LOCAL_HASH_BUCKET
- JoinType: RIGHT_OUTER_JOIN
- BuildBuckets: 8
- BuildConjunctEvaluateTime: 2.851us
- BuildHashTableTime: 60.692us
- CopyRightTableChunkTime: 6.154us
- RuntimeFilterBuildTime: 25.891us
- RuntimeFilterNum: 1