[ https://issues.apache.org/jira/browse/SPARK-27714?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17696543#comment-17696543 ]
Sujith Chacko commented on SPARK-27714: --------------------------------------- [~xinxianyin] any work is in progress for this issue? I saw a PR [https://github.com/apache/spark/pull/24983,] can we reopen the same for the review. Thanks > Support Join Reorder based on Genetic Algorithm when the # of joined tables > > 12 > -------------------------------------------------------------------------------- > > Key: SPARK-27714 > URL: https://issues.apache.org/jira/browse/SPARK-27714 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 3.1.0 > Reporter: Xianyin Xin > Assignee: Xianyin Xin > Priority: Major > > Now the join reorder logic is based on dynamic planning which can find the > most optimized plan theoretically, but the searching cost grows rapidly with > the # of joined tables grows. It would be better to introduce Genetic > algorithm (GA) to overcome this problem. -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org