If you do an insert overwrite select, the result will not have a header even if you set the header to true. E.g  INSERT OVERWRITE DIRECTORY '${HDFSLocation}' row format delimited FIELDS TERMINATED BY '|' null defined as '' select col1,col2,col2 from data_base.table;   the final file or file created will not have headers. ... View more

thank you. I was following this procedure however there was an error in my csv file. For some reason I needed to resave it again as csv. ... View more

I was looking at the wrong directory. This appears to have resolved the issue. Thank you. ... View more

@ Jay Kumar SenSharma thank you for letting me know, as I am new to the community. I will mark this as answered and open another question. ... View more

@Matt, Hope you were successful in copying your files to HDFS. For any other "Getting Started Questions" you might have please check out the Learning the Ropes Hortonworks Tutorial. ... View more