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

do  you have the code for your response, that would be awesome? ... View more