Re: Writing hive column headers in 'Insert overwrite query'

2016-01-13 Thread Elliot West
I created an issue in the Hive Jira related to this. You may wish to vote on it or watch it if you believe it to be relevant. https://issues.apache.org/jira/browse/HIVE-12860 On 13 January 2016 at 09:43, Elliot West wrote: > Unfortunately there appears to be no nice way of doing this. I've se

Re: Writing hive column headers in 'Insert overwrite query'

2016-01-13 Thread Elliot West
Unfortunately there appears to be no nice way of doing this. I've seen others achieve a work around by UNIONing with a table of the same schema, containing a single row of the header names, and then finally sorting by a synthesised rank column (see: http://stackoverflow.com/a/25214480/74772). I be

Re: Writing hive column headers in 'Insert overwrite query'

2016-01-12 Thread Sreenath
Hey, This will work but lets say i want to write the output to an HDFS location using INSERT OVERWRITE DIRECTORY '' , in this case even if we set *hive.cli.print.header=true *the headers doesn't get written . Is there a way to write the headers in this case On 13 January 2016 at 12:04, Ankit Bhat

Re: Writing hive column headers in 'Insert overwrite query'

2016-01-12 Thread Ankit Bhatnagar
r u looking for  hive -e "set hive.cli.print.header=true; < query> " > output  On Tuesday, January 12, 2016 10:14 PM, Sreenath wrote: Hi All, Is there a way we can write the hive column headers also along with the output when we are overwriting a query's output to an HDFS or local dire

Writing hive column headers in 'Insert overwrite query'

2016-01-12 Thread Sreenath
Hi All, Is there a way we can write the hive column headers also along with the output when we are overwriting a query's output to an HDFS or local directory ? -- Sreenath S Kamath Bangalore Ph No:+91-9590989106