title: How to refer broadcast variable in Spark DataFrameSQL
body: <p>I have the following SparkSQL:</p>
  
  <pre><code>val resultDf = spark.sql("SELECT name, phone, country FROM users")
  </code></pre>
  
  <p>I'd like to filter returned records by countries which are present in the following collection:</p>
  
  <pre><code>val countries = Seq("Italy", "France", "United States", "Poland", "Spain")
  </code></pre>
  
  <p>For example I can create the broadcast variable based on the collection:</p>
  
  <pre><code>val countriesBroadcast = sc.broadcast(countries)
  </code></pre>
  
  <p>but is it possible(and if so - how?) to use the <code>countriesBroadcast</code> variable inside of my SQL query?</p>