How to resolve duplicating data with query joins in CosmosDB ?
Article ID: KB0071395
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | - |
Description
While executing a query with joins against Cosmos DB from TDV Studio, you may run into duplicating data for columns that are from a join or you may observe missing columns in the result when functions like IsNull are used in the query :
The cause of the issue is currently the QueryPassthrough option is not supported by CosmosDB
Issue/Introduction
How to resolve duplicating data with query joins in CosmosDB ?
Resolution
QueryPassthrough Option : This property enables you to use native CQL statements instead of SQL.
Currently the option is not supported by CosmosDB and having this option enabled will create errors when trying to execute queries with some particular functions (join, alias, in, like)
In the data source configuration, we have to find the "other" option field, and remove the QueryPassthrough entry, then save the datasource and retry the problematic query.
Currently the option is not supported by CosmosDB and having this option enabled will create errors when trying to execute queries with some particular functions (join, alias, in, like)
In the data source configuration, we have to find the "other" option field, and remove the QueryPassthrough entry, then save the datasource and retry the problematic query.
Feedback
Yes
No
Powered by
