aws / aws/amazon-documentdb-jdbc-driver
[BUG] - Cannot convert from BSON type string to Date
- Dominant language
- Java
- Stars
- 17
- Forks
- 16
- PR merge metrics
- No merged PRs in 30d
Description
## Environment
- DocumentDB JDBC driver version: 1.4.4
- DocumentDB server version: 4.0
- OS: Windows 10 64-bit
- BI Tool or client name: Tableau Desktop
- BI Tool or client version: 2022.1
- Java version (if known): 8.341
---
## Problem Description
1. Steps to reproduce: key field on DocumentDB is Date. However on Tableau appears as string and unable to convert.
2. Expected behaviour: display date on rows field
3. Actual behaviour: error executing query
4. Error message/stack trace:
"Error Code: A96BDB88
Execute query has failed, error: shadow.com.mongodb.MongoCommandException: Command failed with error 16006: 'can't convert from BSON type string to Date' on server documentdb. The full response is {"ok": 0.0, "operationTime": {"$timestamp": {"t": 1692798039, "i": 1}}, "code": 16006, "errmsg": "can't convert from BSON type string to Date"}."
Contributor guide
Assessment
This issue has not been assessed yet.