Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How do to show query results as tab delimited in hive

avatar
Explorer

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 REPLIES 2

avatar
Super Guru

@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

avatar
Explorer

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.