How to specify delimiter in Hive select query

2013-08-23 Thread Shailesh Samudrala
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

Re: How to specify delimiter in Hive select query

2013-08-23 Thread Jagat Singh
This is not possible till hive 0.10 in hive 0.11 there is patch to do.this. You can insert to some temp.table with required delimiter or use some pig action to.replace afterwards. Or best use hive 0.11 On 24/08/2013 10:45 AM, Shailesh Samudrala shailesh2...@gmail.com wrote: I'm querying a Hive