title: How to convert json array<String> to csv in spark sql
body: <p>I have tried this query to get required experience from linkedin data.</p>
  
  <p><img src="https://i.stack.imgur.com/LOFgA.png" alt="click here for my data"></p>
  
  <pre><code> Dataset&lt;Row&gt; filteredData = spark
                      .sql("select full_name ,experience from (select *, explode(experience['title']) exp from tempTable )"
                              + "  a where lower(exp) like '%developer%'");
  </code></pre>
  
  <p>But I got this error:</p>
  
  <p><img src="https://i.stack.imgur.com/C0zXJ.png" alt="click here for error I got"></p>
  
  <p>and finally I tried  but I got more rows with the same name .</p>
  
  <pre><code>Dataset&lt;Row&gt; filteredData = spark
                      .sql("select full_name ,explode(experience) from (select *, explode(experience['title']) exp from tempTable )"
                              + "  a where lower(exp) like '%developer%'");
  </code></pre>
  
  <p>Please give me hint, how to convert array of string to comma separated string in the same column.</p>