aws-athena-query-federation: [BUG] DocumentDB connector can't handle collections with uppercase letters

If the collection name has an uppercase letter, querying it will result in an error.

To Reproduce Steps to reproduce the behavior:

  1. Set up DocumentDB and the DocumentDB connector for Athena.
  2. Insert a document into a collection with a uppercase letter in the name in DocumentDB: db.T1.insert({})
  3. In Athena, query the collection: select * from T1
  4. See error

Expected behavior Either the query should happen successfully(attempt the test without uppercase letters), or the project documentation should mention this as a limitation.

Your query has the following error(s):

NOT_SUPPORTED: Table has no columns: documentdb:com.amazonaws.presto.connectors.lambda.handles.LambdaTableHandle@5e78097a

This query ran against the "test" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: f8831726-435a-4041-ae49-35a737a35c8e.

Connector Details (please complete the following information):

  • Version: 2021.27.1
  • Name: AthenaDocumentDBConnector
  • Athena Query IDs: f8831726-435a-4041-ae49-35a737a35c8e

Additional context

We are using Spring framework to write DocumentDB and by default it uses the Java class name appended with Entity as the collection name, for exmaple for a class name Record, the Documentdb collection would be recordEntity by default.

About this issue

  • Original URL
  • State: closed
  • Created 3 years ago
  • Comments: 22 (10 by maintainers)

Most upvoted comments

I wasn’t the one that closed this issue, but sure I can reopen it.

@henrymai Can you reopen this issue? It seems like a fair assumption that I’m not the only one stuck with a schema that’s not in lowercase and no remedy available…