How to convert json array<String> to csv in spark sql
<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>