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

CYN
已提问 6 个月前236 查看次数
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
专家
已回答 6 个月前

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

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

回答问题的准则