I am trying to move data from a CSV stored in S3 to an Athena table to test. I cannot use Glue and this seems to be the only way.

The CSV data isn't perfect obviously but I am getting the following error. There are no columns specified in the error. The code prior to this is CREATE TABLE with the column types.

HIVE_BAD_DATA: Error Parsing a column in the table: For input string: ""

ROW FORMAT SERDE '.apache.hadoop.hive.serde2.OpenCSVSerde'
WITH SERDEPROPERTIES ("separatorChar" = ",", "quoteChar" = "\"")
LOCATION 's3://myfolder/folder1/'
TBLPROPERTIES (
    'skip.header.line.count' = '1',
    'serialization.null.format'='')