使用AWS re:Post即您表示您同意 AWS re:Post 使用条款
AWS re:Postre:Post

Athena query results returning all data in one column

0

i have a table in data catalog and when i query the table, all the data in that table are return in one column separated by commas. It's like its returning the CSV file exactly as it is without separating the file

主题
分析
标签
Amazon Athena
语言
English
CYN
已提问 7 个月前280 查看次数
1 回答
0

Follow these steps to identify the issue and perform the fix.

1- Do a DESCRIBE TABLE . read details here https://docs.aws.amazon.com/athena/latest/ug/describe-table.html

2- Verify the ROW FORMAT SERDE . Read this link to learn how to setup a SERDE for CSV files . https://docs.aws.amazon.com/athena/latest/ug/csv-serde.html

AWS
专家
Dipankar_G
已回答 7 个月前

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

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

回答问题的准则

相关内容