Hey, This will work but lets say i want to write the output to an HDFS location using INSERT OVERWRITE DIRECTORY '<Query>' , 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 Bhatnagar <ank...@yahoo-inc.com> wrote: > r u looking for > > hive -e "*set hive.cli.print.header=true*; < query> " > output > > > On Tuesday, January 12, 2016 10:14 PM, Sreenath <sreenaths1...@gmail.com> > 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 > directory ? > > > -- > Sreenath S Kamath > Bangalore > Ph No:+91-9590989106 > > > -- Sreenath S Kamath Bangalore Ph No:+91-9590989106
