02-07-2017 10:44 PM
In hive,One of my column data contains Pipe as the part of the data('|'),however, while exporting data from this table,we need to export the data as the pipe('|') as the delimiter between each fields,How to handle if the delimiters as part of the data while creating the flat file from the hive table.
02-08-2017 07:14 AM
Like a proper CSV format you need to determined three specials characters :
* The field delimiter
* The end-of-line character
* The quote character (for protecting the delimiter and the end-of-line character)
For exemple :
* The field delimiter : ,
* The end-of-line character : "
* The quote character (for protecting the delimiter and the end-of-line character) : \n
This line :
Should be read as 3 fields (toto), (tata) and (toto,tata)