https://community.cloudera.com/t5/Support-Questions/How-do-to-show-query-results-as-tab-delimited-in-hive/m-p/294307#M217179 <P>It will create a new table but the requirement is to show the results of SQL in tab delimited. If we create a now table as \t delimited and then again select * from that new format table , wouldn't it will show with default "|" delimited.</P> Sun, 19 Apr 2020 17:14:01 GMT Hive_SQL 2020-04-19T17:14:01Z