apologies, my command was
hive -e "set hive.cli.print.header=true; *select * from abc*" >> output.txt Thank you, *Pushkar Gujar* On Wed, Mar 8, 2017 at 8:49 PM, Pushkar.Gujar <pushkarvgu...@gmail.com> wrote: > if you were running CTAS command from hive CLI, you might have noticed > that headers get printed in CLI once the query execution is completed. I > think the property hive.cli.print.header is there to only print headers > only in cli. > > Not sure about S3, but I tried below which worked perfectly > > hive -e "set hive.cli.print.header=true; create table....." >> output.txt > > > Thank you, > *Pushkar Gujar* > > > On Wed, Mar 8, 2017 at 6:47 PM, Punit Shetty <punitshett...@gmail.com> > wrote: > >> Hi, >> >> I'm trying to get the column headers into a S3 file. >> >> When I run this on the hive command line: >> set hive.cli.print.header=true; >> select * from abc; >> >> Things work fine, I'm able to see the column headers with the table data >> on the console. >> >> But my query is, when I try something like this: >> set hive.cli.print.header=true; >> CREATE TABLE test123 ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES >> TERMINATED BY '\n' STORED AS TEXTFILE LOCATION 's3://somelocation' AS >> select * abc; >> >> The column headers are missing from the S3 file. >> >> Is this the expected behaviour or am I missing something? >> >> Thanks, >> Punit >> > >