'[MongoDB]Although the query doesn't contain $literal, error message shows $literal is not supported

I want to use Tableau to analysis some data which from AWS DocumentDB. I use the MongoDB BI connector and the network access is successful. But when I open the worksheet in Tableau. Some fields have no problems but some fields don't work well. The error details are as follows:

[MySQL][ODBC 8.0(w) Driver][mysqld-5.7.12 mongosqld v2.13.3]error running aggregation: Aggregation project operator not supported: '$literal'
SELECT SUM(1) AS `sum_Number of Records_ok`
FROM `OrderGroup`
HAVING (COUNT(1) > 0)

As you can see the SQL query doesn't contain $literal. And the $literal is also supported by AWS DocumentDB. https://docs.aws.amazon.com/documentdb/latest/developerguide/mongo-apis.html Thank you very much for read my question.

mysqlsqlmongodbtableau-apiaws-documentdb


Solution 1:[1]

$literal support was added to DocumentDB in Oct 2021 (https://aws.amazon.com/about-aws/whats-new/2021/10/amazon-documentdb-adds-additional-mongodb-compatibility-apis/).

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 allco

Related Questions