1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
json is not a data type supported by glue. You would have to choose between one of these - BOOLEAN | DATE | DECIMAL | DOUBLE | LONG | STRING | BINARY. In your case when you have a JSON, you need to define those as a String column and cast it into a String.
You should be able to query this data with Athena. When you query this table you can use the JSON functions to query the JSON columns, for example:
SELECT json_extract_scalar(attributes, '$.tag1') ...
glue : https://docs.aws.amazon.com/glue/latest/dg/aws-glue-api-common.html
athena : https://docs.aws.amazon.com/athena/latest/ug/data-types.html
répondu il y a 2 ans
Contenus pertinents
- demandé il y a 2 mois
- demandé il y a un an
- demandé il y a 7 mois
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 3 ans
What to do in a situation when you cannot change DB schema that has JSON column? Non of the suggested type would work as the Writing action would thrown an exception. This seems a massive oversight for Glue