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-ValueOutputFormats (If this is what you are looking for, let me know by accepting the answer. Else, let me know the gaps in the answer). ... View more