Glue crawler unable to detect array of strings column

0

I have some CSV data that have an array of strings. For example, I want to extract two columns:

USGLS,"['MXMAR', 'BZBZE', 'MXCZM']",TEST

Unfortunately, the Glue CSV crawler (after executing it) determines the second column to be a string. Moreover, the crawler believes the second column value is:

"['MXMAR'

while the third column value is:

'BZBZE'

Editing the schema for the data catalog doesn't allow me to change the data type of the column to an array type. How can I change the column data type to an array of strings?

已提问 2 年前88 查看次数
没有答案

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

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

回答问题的准则