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


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 <docdb_database>.<collection>

I get the following error:

TYPE_NOT_FOUND: Unknown type: row

asked a year ago407 views
2 Answers

I believe you need to specify the lambda function name which is created when installing the connector. Something like this SELECT * FROM "lambda:<lambda name>".<docdb_database>.<collection> ; See also the Amazon DocumentDB lab about how to create and query using the connector.

Mihai A
answered a year ago

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

answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions