My Hadoop interview scenario based query -solution can be in HIVE/PIG/MapReduce
<p>I have data in a file like below(comma(,) separated).</p>

<pre><code>ID,Name,Sal
101,Ramesh,M,1000
102,Prasad,K,500
</code></pre>

<p>I want the output table to be like below</p>

<pre><code>101, Ramesh M, 1000
102, Prasad K, 500
</code></pre>

<p>i.e Name and Surname in a single column in the output</p>

<p>In Hive if I give row format delimited fields terminated by ',' it will not work. Do we need to write a serde?</p>

<p>Solution can be in MR or PIG also.</p>