In Pig

CSVExcelStorage loader support to skip the header row

// input.csv

Name,Age,Location
a,10,chennai
b,20,banglore

REGISTER '/tmp/piggybank.jar';
A = LOAD 'input.csv' USING org.apache.pig.piggybank.storage.CSVExcelStorage(',', 'NO_MULTILINE', 'UNIX', 'SKIP_INPUT_HEADER');
DUMP A;

 // Output

(a,10,chennai)
(b,20,banglore)


In Hive

you can use hive's property which is TBLPROPERTIES ("skip.header.line.count"="1") 

CREATE TABLE temp 
  ( 
     name STRING, 
     id INT 
  ) 
row format delimited fields terminated BY '\t' lines terminated BY '\n' 
tblproperties("skip.header.line.count"="1");