I'm querying a Hive table on my cluster, (*select * from <table_name>;*) and writing this select output to output file using (*INSERT OVERWRITE DIRECTORY*). When the I open the output file, I see that the columns are delimited by Hive's default delimiter (*^A or ctrl-A*).
So my question is, is there a way I can select data from the table and use a tab or space delimiter? Thanks a lot for your help! Shailesh