aws / aws/amazon-documentdb-jdbc-driver

[BUG] - Cannot convert from BSON type string to Date

Open
#552 2 comments 0 reactions 0 assignees View on GitHub
bug
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.