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

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

Create single file inside partition while inserting

Hi, We are facing some issues with hive jobs while inserting into tables. It creating a very large file (single file of 100s of GB) per partition. We were able to create multiple files (size ~ 200-300 MB) on the older hive (V 0.11) on AWS emr version 2.4.2. But once we upgraded to the new

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