Re: Missing column headers from S3 file

Yes, running the CTAS command on hive CLI does print the headers once the query execution is completed. I think this feature is yet to be implemented: https://issues. apache.org/jira/browse/HIVE-12860 On Thu, Mar 9, 2017 at 9:50 AM, Punit Shetty wrote: > Yes, running

Re: Missing column headers from S3 file

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 wrote: > if you were running CTAS command from hive CLI, you might have noticed > that

Re: Missing column headers from S3 file

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

Missing column headers from S3 file

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