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:
- Set up DocumentDB and the DocumentDB connector for Athena.
- Insert a document into a collection with a uppercase letter in the name in DocumentDB:
db.T1.insert({}) - In Athena, query the collection:
select * from T1 - 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)
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…