Relative Content

Tag Archive for amazon-web-servicesamazon-dynamodbamazon-athena

Athena DynamoDB Connector Table Schema Has Map Attribute with UUID Key

I have connected a dynamoDB table to Athena using the DynamoDB Connector. However, when I check the table schema in Athena Query Editor, I find it is inferred incorrectly. In the table, I have a large nested map attribute as the value with a UUID as the key for that map attribute. As the UUIDs are unique to each row in the table, since Athena has inferred the table schema from a subset of the table, the schema now has the UUID in it, which means I cannot query for that attribute at ALL, as only the row with that UUID will be returned correctly even in a simple SELECT * FROM TABLE_a statement. I understand using a Glue Crawler set up would solve this issue, but I want to keep costs down and wanted to try and work with the DynamoDB connector if possible.