I have a table in hive which has a list in it - created using collect\_set. When I query the table and send the output to a csv file the list becomes different columns instead of one column. 

query 

```
 hive - e "Select col1 from table" | sed 's/[\t]/,/g'  > output.csv

```

The current csv ouput has two columns like this 

```
  col1         col2
 ["Apple"      "Mango"]
 ["Apple"      "Pineapple"]
 ["Orange"     "Mango"]
 ["Apple"      "Mango"]

```

How can I have my file output is as one column col1:

```
 col1
 ["Apple","Mango"]
 ["Apple","Pineapple"]
 ["Orange","Mango"]
 ["Apple","Mango"]

```