Skip first line of csv while loading in hive table

by

To get this you can use hive’s property which is TBLPROPERTIES (“skip.header.line.count”=”1”)
you can also refer example –

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

Leave a Comment