Glue processing a csv

0

I am having a csv file on a s3 bucket and using a glue crawler to have a table created on Athena. The table gets created but the data gets messed up. The values gets shifted to the adjacent columns for some of the records. Is there any way to mitigate this? Does glue work fine for csv files or do the files need to be converted to a paruqet or json.

AWS
已提问 4 年前406 查看次数
1 回答
0
已接受的回答

Glue should work fine with CSV or any other delimited format. When you mentioned "some records", can you validate that the csv row corresponding to those records are well-formatted ? You can compare how Glue perform by using EMR Hive to create a s3-backed table.

AWS
wijayah
已回答 4 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则