I need to join a dataframe with a string column to one with array of string so that if one of the values in the array is matched, the rows will join.

I tried this but I guess it's not support. 
Any other way to do this?

```
import org.apache.spark.SparkConf
import org.apache.spark.sql.SparkSession

val sparkConf = new SparkConf().setMaster("local[*]").setAppName("test")
val spark = SparkSession.builder().config(sparkConf).getOrCreate()

import spark.implicits._

val left = spark.sparkContext.parallelize(Seq(1, 2, 3)).toDF("col1")
val right = spark.sparkContext.parallelize(Seq((Array(1, 2), "Yes"),(Array(3),"No"))).toDF("col1", "col2")

left.join(right,"col1")

```

Throws:

> 
> org.apache.spark.sql.AnalysisException: cannot resolve '(`col1`
>  =`col1`)' due to data 
>  type mismatch: differing types in '(`col1` =
> 
> 
> `col1`)' (int and array).;;
> 
> 
>