I am trying to read csv file from s3 bucket and create a table in AWS Athena. My table when created is unable to skip the header information of my CSV file.
Query Example :
CREATE EXTERNAL TABLE IF NOT EXISTS table_name ( `event_type_id`
string, `customer_id` string, `date` string, `email` string )
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.OpenCSVSerde'
SERDEPROPERTIES ( "separatorChar" = "|", "quoteChar" = "\"" )
This doesn't seem to work. Is there any other way that I could get through this?