title: select data from Hive where column value in list
body: <p>I would like to get data from Hive such that: if one column value is in List, then select data from Hive. </p>
  
  <p>Example Data in Hive table is as:  </p>
  
  <pre><code>Col1   | Col2 | Col3
  -------+---------------
  Joe    | 32   | Place-1
  Nancy  | 28   | Place-2
  Shalyn | 35   | Place-1
  Andy   | 20   | Place-3
  </code></pre>
  
  <p>I am querying Hive table as: </p>
  
  <pre><code>val name = List("Sherley","Joe","Shalyan","Dan")
  var dataFromHive = sqlCon.sql("select Col1,Col2,Col3 from default.NameInfo where Col1 in (${name})")
  </code></pre>
  
  <p>I know that my query is wrong, as its throwing error. But I am not able to get proper replacement for <code>where Col1 in (${name})</code>.</p>