Glue处理CSV文件的格式问题

0

【以下的问题经过翻译处理】我在s3存储桶中有一个csv文件，并使用一个glue爬虫在Athena上创建一个表。表已创建，但数据出现了问题。部分记录的值被移动到相邻的列中。有没有办法解决这个问题？glue是否适用于csv文件，还是需要将文件转换成parquet或json格式？

Topics

Tags

Language

中文 (简体)

EXPERT

rePost Polyglot

asked 5 months ago15 views

1 Answer

Newest
Most votes
Most comments

Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.

0

【以下的回答经过翻译处理】 Glue可以很好地处理CSV或其他分隔格式。当你提到"一些记录"时，您可以验证与这些记录对应的CSV行是否格式良好？您可以使用EMR Hive创建一个基于S3的表来和Glue进行比较。

EXPERT

rePost Polyglot

answered 5 months ago

Relevant content

S3上无法使用Chunked上传文件｜ Unable to use Chunked to upload files on S3
rePost-User-1798329
asked a year ago
sagemaker美国人口普查数据在中国宁夏区下载提示拒绝访问
LiuChuang
asked a year ago
CloudFront创建使用问题
rePost-User-2764828
asked a year ago
怎样通过CloudFormation来给DocumentDB创建一些表和索引(how to create some table and index in DocumentDB by CloudFormation）
Accepted Answer
Dgk
asked 10 months ago
How can I store an Amazon Athena query output in a format other than CSV, such as a compressed format?
AWS OFFICIALUpdated 2 years ago
How can I prevent the AWS Glue crawler from creating multiple tables?
AWS OFFICIALUpdated a year ago
How can I access Amazon S3 Requester Pays buckets from AWS Glue, Amazon EMR, or Amazon Athena?
AWS OFFICIALUpdated 2 years ago
How do I use pivoted data after an AWS Glue relationalize transformation?
AWS OFFICIALUpdated 3 years ago
Returning AWS Config aggregator results as CSV
EXPERT
James_S
published 2 years ago
Migrating Glue Data Catalog tables to use Apache Iceberg open table format using Athena
EXPERT
Hamzah Chaudhry
published a month ago