Dumping the beeline output to a file, by default it is giving comma seperated file. I would like to add the delimiter as "|"(PIPE) instead of comma(,)

[#1 · Accepted solution]

Use

--outputformat=dsv 

This output format is configurable, but the default is a pipe so the above should be sufficient for your needs.

If you want to use something else as a delim, add

--delimiterForDSV=DELIMITER

For more details, see: https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-Separated-Va...

(If this is what you are looking for, let me know by accepting the answer. Else, let me know the gaps in the answer).