How do to show query results as tab delimited in hive

[#1]

HI,

I am planning to run select queries saves in .sql file. I wanted to run those queries in hive and 

wanted to show results of my select queries as tab delimited rather default "|" . Please let me know what is the way to show query results as tab delimited in hive.

[#2]

@Hive_SQL The solution here is to create a hive table of New Format (|).   Next Select/Insert Old Format(/t) into New Format.

For example: select * from old_format INSERT INTO new_format

[#3]

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.