Hi,
I've tried to run the following DDL statement in Athena:
querying GZIP compressed CSV files
For some reason, it won't remove the first line, neither the quotes character (") from the output.
I've found a relevant thread on AWS forums where other people that ran into this issue as well:
https://forums.aws.amazon.com/thread.jspa?messageID=755357&threadID=244207&tstart=0
Would love to hear your thoughts about this.
DDL Statement:
CREATE EXTERNAL TABLE IF NOT EXISTS table_name_here (
eventID STRING,
userID STRING,
sessionID STRING,
eventDate STRING,
eventTimestamp STRING,
eventName STRING,
eventLevel INT,
gaUserStartDate STRING,
gaUserGender STRING,
gaUserAgeGroup STRING,
gaUserCountry STRING,
gaUserAcquisitionChannel STRING,
msSinceLastEvent STRING,
browserName STRING,
browserVersion STRING,
campaign STRING,
clientVersion STRING,
collectInsertedTimestamp STRING,
convertedProductAmount STRING,
externalUserID STRING,
mainEventID STRING,
network STRING,
operatingSystem STRING,
operatingSystemVersion STRING,
parentEventID STRING,
platform STRING,
productAmount STRING,
productCategory STRING,
productID STRING,
productName STRING,
productType STRING,
realCurrencyAmount INT,
realCurrencyType STRING,
revenueValidated INT,
signupSource STRING,
transactionID STRING,
transactionName STRING,
transactionSourceId INT,
transactionSourceName STRING,
transactionStatus STRING,
transactionType STRING,
transactionVector STRING,
userLevel INT,
userType STRING,
virtualCurrencyAmount INT,
virtualCurrencyName STRING,
virtualCurrencyType STRING,
visitSource STRING
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
LOCATION 's3://path/to/bucket'
TBLPROPERTIES (
"skip.header.line.count"="1",
"quoteChar"='"'
);