1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
1
Hello,
Please note that errors that specify a null or empty input string ("For input string: "") happen when both of the following are true:
- You're using Athena with OpenCSVSerDe, which means that your source data uses double quotes (") as the default quote character.
- The source data contains null values ("") or empty cells.
You can refer the same in the below document: https://aws.amazon.com/premiumsupport/knowledge-center/athena-hive-bad-data-error-csv/
It seems that this error is occurring because there are empty cells for some of columns
As mentioned in the above document in order to mitigate the issue “Define each column as STRING. The parser in Athena parses the values from STRING into actual types based on what it finds. This prevents Athena from throwing an error when it finds null values (empty strings with double quotes and no spaces) or empty cells (no values or double quotes).”
답변함 2년 전