Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
MapReduce >> mail # user >> How to specify delimiter in Hive select query

Copy link to this message
Re: How to specify delimiter in Hive select query
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" <[EMAIL PROTECTED]> wrote:

> 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