1 回答
- 最新
- 投票最多
- 评论最多
0
Hello,
Error "Fatal exception com.amazonaws.services.glue.readers unable to parse file *.csv" is observed when CSV is either not "UTF-8" encoded or if it has non UTF-8 encoded characters.
As you have already verified that your CSV file is UTF-8 encoded and you mentioned that data has some special characters, please try running ETL job after removing these characters from file.
Using a semi colon separated CSV file I have tested in my personal AWS account, I was able to run Glue ETL job successfully using the from_catalog function.
Steps I followed for this test:
1. Created a sample semi colon seprated CSV file.
2. Created the table from this file using Glue Crawler.
3. Created a Glue ETL job to read this table using from_catalog function
Thank you so much, when I did the conversion to CSV UTF-8 it appears the code was corrupted so the problem persisted but removing some characters before the conversion worked.
相关内容
- AWS 官方已更新 3 年前
- AWS 官方已更新 3 个月前
Can you share the full stacktrace, there should be a "Caused by" part giving more information