TYPE_NOT_FOUND: Unknown type: row error in Athena querying a DocDB data source

Question

I setup a Document DB Data Source in Athena using a pre-defined Lambda function as per https://docs.aws.amazon.com/athena/latest/ug/connectors-docdb.html.

Athena can see the data source and collections within the DocDB database, but when I try to query anything with a

```
SELECT * FROM .
```

I get the following error:

TYPE_NOT_FOUND: Unknown type: row

Answer

I believe you need to specify the lambda function name which is created when installing the connector. Something like this ```SELECT * FROM "lambda:".. ;``` 
See also the Amazon DocumentDB [lab](https://catalog.us-east-1.prod.workshops.aws/workshops/464d6c17-9faa-4fef-ac9f-dd49610174d3/en-US/change-streams/querydocdbwithathena) about how to create and query using the connector.

Answer

This does not solve the problem, do you know another solution?

TYPE_NOT_FOUND: Unknown type: row error in Athena querying a DocDB data source

Contenuto pertinente