https://community.cloudera.com/t5/Support-Questions/How-do-to-show-query-results-as-tab-delimited-in-hive/m-p/293810#M216894 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/76672">@Hive_SQL</a>&nbsp;The solution here is to create a hive table of New Format (|). &nbsp; Next Select/Insert Old Format(/t) into New Format.</P><P>&nbsp;</P><P>For example: select * from old_format INSERT INTO new_format</P> Mon, 13 Apr 2020 13:04:00 GMT stevenmatison 2020-04-13T13:04:00Z