How to resolve duplicating data with query joins in CosmosDB ?
book
Article ID: KB0071395
calendar_today
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
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.
Issue/Introduction
How to resolve duplicating data with query joins in CosmosDB ?