Spark报错：Detected cartesian product for LEFT OUTER join between logical plans

[Spark报错]:Detected cartesian product for LEFT OUTER join between logical plans

FBI warning：xian si kao yao bu yao di ka er cha xun, If true Then return

注意：先思考一下自己sql语句是不是真的需要笛卡尔查询，如果是的话，本文跳过

开门见山

测试程序:

import java.util

import org.apache.spark.sql.{DataFrame, Row, SparkSession}
import org.apache.spark.sql.types.{IntegerType, StringType, StructField, StructType}

import scala.collection.JavaConverters._

object SparkTestJoin {
  def main(args: Array[String]): Unit = {
    val spark: SparkSession = SparkSession.builder().master("local[*]").getOrCreate()

    val java: util.List[Row] = List[Row](
      Row(1, "zhangsan", 86),
      Row(2, "lisi", 97),
      Row(3, &