...
Starting with Hive 0.14, there are improved SV formats availableoutput formats available, namely DSV, CSV2 and TSV2. These are in-line with conform better to standard CSV convention, which adds quotes only when around a cell contains value only it contains special characters, such as the delimiter char, a quote char, or spans multiple lines. They These three formats differ only with the delimiter between cells, which is comma for CSV2, tab for TSV2, and configurable for DSV (delimiterForDSV property).
CSV and TSV output formats are maintained for backward compatibility, but beware as they add additional single-quote characters around all cell values contrary to this convention.
...