[oracle@centos ~]$ head -5 1998.csv
Year,Month,DayofMonth,DayOfWeek,DepTime,CRSDepTime,ArrTime,CRSArrTime,UniqueCarrier,FlightNum,TailNum,ActualElapsedTime,CRSElapsedTime,AirTime,ArrDelay,DepDelay,Origin,Dest,Distance,TaxiIn,TaxiOut,Cancelled,CancellationCode,Diverted,CarrierDelay,WeatherDelay,NASDelay,SecurityDelay,LateAircraftDelay
1998,1,17,6,715,715,840,840,WN,76,N520,145,145,137,0,0,AUS,PHX,872,3,5,0,NA,0,NA,NA,NA,NA,NA
1998,1,18,7,715,715,830,840,WN,76,N302,135,145,127,-10,0,AUS,PHX,872,2,6,0,NA,0,NA,NA,NA,NA,NA
1998,1,19,1,715,715,831,840,WN,76,N315,136,145,128,-9,0,AUS,PHX,872,3,5,0,NA,0,NA,NA,NA,NA,NA
1998,1,20,2,715,715,836,840,WN,76,N372,141,145,126,-4,0,AUS,PHX,872,3,12,0,NA,0,NA,NA,NA,NA,NA
[oracle@centos ~]$ sed '1d' 1998.csv >> 1998b.csv
[oracle@centos ~]$ head -2 1998b.csv
1998,1,17,6,715,715,840,840,WN,76,N520,145,145,137,0,0,AUS,PHX,872,3,5,0,NA,0,NA,NA,NA,NA,NA
1998,1,18,7,715,715,830,840,WN,76,N302,135,145,127,-10,0,AUS,PHX,872,2,6,0,NA,0,NA,NA,NA,NA,NA
[oracle@centos ~]$ hadoop fs -put 1998b.csv /user/oracle/1998b.csv
[oracle@centos ~]$ hive
hive> load data inpath '/user/oracle/1998b.csv'
> overwrite into table airline_delay
> partition ( delayYear='1998');
hive> select count(*) from airline_delay;