https://community.cloudera.com/t5/Support-Questions/Skipping-Headers-in-Hive/m-p/37995#M7157 Hive provides a skip header/footer feature when creating your table (as part of table properties). See the release notes on <A href="https://issues.apache.org/jira/browse/HIVE-5795" target="_blank">https://issues.apache.org/jira/browse/HIVE-5795</A><BR /><BR />"""<BR />CREATE TABLE testtable (name STRING, message STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' TBLPROPERTIES ("skip.header.line.count"="1");<BR /><BR />LOAD DATA LOCAL INPATH '/tmp/header-inclusive-file.csv' INTO TABLE testtable;<BR />""" Sun, 28 Feb 2016 05:35:20 GMT Harsh J 2016-02-28T05:35:20Z