hive的几种join、Spark中RDD、DF和DS的几种join

HIVE

1. join
2. left out join
3. right out join
4. full out join
5. left semi join
6. cross join

SparkRDD:

1. join
2. leftOutJoin
3. rightOutJoin
4. fullOutJoin

使用示范：
 val b: RDD[(Int, String)] = a.keyBy(x=>x.length)
    val c=b
      b.fullOuterJoin(b)

Spark DF、DS：

1.  inner
2. outer, full, fullouter
3. leftouter, left
4. rightouter, right
5. leftsemi
6. leftanti
7. cross

使用示范：

import  spark.implicits._
val df2 = b.toDF("x","y")
val df3=df2
df2.join(df3,df2("x")===df3("x"),"leftouter").show

源码： 

object JoinType {
  def apply(typ: String): JoinType = typ.toLowerCase(Locale.ROOT).replace("_", "") match {
    case "inner" => Inner
    case "outer" | "full" | "fullouter" => FullOuter
    case "leftouter" | "left" => LeftOuter
    case "rightouter" | "right" => RightOuter
    case "leftsemi" => LeftSemi
    case "leftanti" => LeftAnti
    case "cross" => Cross
    case _ =>
      val supported = Seq(
        "inner",
        "outer", "full", "fullouter",
        "leftouter", "left",
        "rightouter", "right",
        "leftsemi",
        "leftanti",
        "cross")

      throw new IllegalArgumentException(s"Unsupported join type '$typ'. " +
        "Supported join types include: " + supported.mkString("'", "', '", "'") + ".")
  }
}