I know this post was a long time ago, but does the script below add text qualifiers if a field contains one or more  '|'?   INSERT OVERWRITE DIRECTORY '/tmp/text-pipe' ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' STORED AS TEXTFILE SELECT * FROM textcomma; Thanks!  ... View more