How to resolve the error HIVE_INVALID_METADATA: Glue table 'ctr-db.11' column 'segmentattributes' has invalid data type: struct<connect\:Subtype:struct<ValueString:string>>

0

I have a CTR data in JSON format stored in s3 bucket which has the below column "SegmentAttributes": { "connect:Subtype": { "ValueString": "connect:Telephony" } } Due to the presence of ":" in "connect:Subtype" I see the below error HIVE_INVALID_METADATA: Glue table 'ctr-db.11' column 'segmentattributes' has invalid data type: struct<connect:Subtype:structValueString:string>

Athena query: SELECT * FROM "ctr-db"."11" limit 10;

How do I resolve the error if I wish to not modify the data? Can I ignore thus column?

已提問 5 個月前檢視次數 355 次
1 個回答
0

I think it could be possible rename the struct field in the schema to avoid the issue, the that on that field won't be read but the query should run.

profile pictureAWS
專家
已回答 5 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南