- last edited on
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.
@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
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.