Greenplum在创建外部表的时候，csv格式的数据文件如何跳过第一行的字段名

Question

CREATE TABLE flights(
year integer ,
month integer ,
dayofmonth integer   ,
dayofweek integer   ,
deptime integer   ,
crsdeptime integer   ,
arrtime integer   , 
crsarrtime integer   ,
uniquecarrier varchar(10)   ,
flightnum integer   ,
tailnum varchar(10)   , 
actualelapsedtime integer   ,
crselapsedtime integer  ,
airtime varchar(5)   ,
arrdelay integer   ,
depdelay integer   , 
origin varchar(5)   ,
dest varchar(5)   ,
distance integer   ,
taxiin varchar(5)  ,
taxiout varchar(5)   ,
cancelled integer   ,
cancellationcode varchar(5)  ,
diverted integer   ,
carrierdelay varchar(5)  ,
weatherdelay varchar(5)   ,
nasdelay varchar(5)   ,
securitydelay varchar(5)   ,
lateaircraftdelay varchar(5)    
)

CREATE READABLE EXTERNAL TABLE e_flights (LIKE flights)
LOCATION ('flights.csv.gz') FORMAT 'csv'

第一行是Title

head -1 flights.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

如何忽略第一行？

Answer 1

CREATE READABLE EXTERNAL TABLE e_flights (LIKE flights)
LOCATION ('flights.csv.gz') FORMAT 'csv' (HEADER);