search

aws / amazon-documentdb-jdbc-driver

Amazon DocumentDB JDBC driver to connect from BI tools and execute SQL Queries
Apache License 2.0
13 stars 14 forks source link

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

Open MANDLA15 opened 1 year ago

MANDLA15 commented 1 year ago

Environment

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"}."
narek commented 1 year ago

Hi @MANDLA15 Thanks for reporting a bug. I'll have a look at it.

narek commented 11 months ago

Hi @MANDLA15 $convert is not supported in DocumentDB yet. We'll update our release notes, once we add a support for $convert operator.