hadoop-common-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shailesh Samudrala <shailesh2...@gmail.com>
Subject How to specify delimiter in Hive select query
Date Sat, 24 Aug 2013 00:45:25 GMT
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

Mime
View raw message