godfrey he created FLINK-15004: ---------------------------------- Summary: Choose SortMergeJoin instead of HashJoin if the statistics is unknown Key: FLINK-15004 URL: https://issues.apache.org/jira/browse/FLINK-15004 Project: Flink Issue Type: Sub-task Components: Table SQL / Planner Affects Versions: 1.9.1, 1.9.0 Reporter: godfrey he Fix For: 1.10.0
Currently, blink planner will use default rowCount value (defined in {{FlinkPreparingTableBase#DEFAULT_ROWCOUNT}} ) when the statistics is unknown, and maybe choose {{HashJoin}} instead of {{SortMergeJoin}}. The job will hang if the build side has huge input size. So It's better to use {{SortMergeJoin}} for execution stability if the statistics is unknown. -- This message was sent by Atlassian Jira (v8.3.4#803005)