Support Questions
Find answers, ask questions, and share your expertise

How do to show query results as tab delimited in hive

How do to show query results as tab delimited in hive

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
Highlighted

Re: How do to show query results as tab delimited in hive

@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

Highlighted

Re: How do to show query results as tab delimited in hive

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.