DocumentDb-不希望从聚合函数获得完整结果的查询 [英] DocumentDb - Query that expects full results from aggregate functions is not supported
问题描述
当我对DocumentDb发出linq计数时. 第一个POST网络请求导致一个400错误的请求
When I issue a linq count against DocumentDb. The first POST web request results in a 400 Bad request
请求json:
{"query":"SELECT VALUE Count(1) FROM root
WHERE ((((root[\"docType\"] = \"Whatever\")
AND (root[\"field1\"] = false))
AND (root[\"field2\"] = true))
AND (root[\"field3\"] = 1)) "}
消息: 不支持期望聚合函数提供完整结果的查询
Message: Query that expects full results from aggregate functions is not supported
其后是GET分区键范围.
This is followed by a GET partition key ranges.
然后另一个对计数查询有效的POST网络请求:
Then another POST web request for the count query which works:
请求json:
{"query":"SELECT VALUE [{\"item\": Count(1)}]\r\nFROM root\r\n
WHERE ((((root[\"docType\"] = \"Whatever\")
AND (root[\"field1\"] = false))
AND (root[\"field2\"] = true))
AND (root[\"field3\"] = 1))"}
我在这里做错什么吗?还是对documentDb预期的行为?
Am I doing something wrong/silly here or is this expected behaviour for documentDb.
谢谢
Donal
推荐答案
不支持期望聚合函数提供完整结果的查询
Query that expects full results from aggregate functions is not supported
我进行了测试,并且出现相同的错误" 查询不支持期望聚合函数提供完整结果的查询 ".如果x-ms-documentdb-query-iscontinuationexpected
请求标头设置为false,则会出现在我的身边.
I do a test and same error "Query that expects full results from aggregate functions is not supported" appears on my side if x-ms-documentdb-query-iscontinuationexpected
request header is set to false.
将x-ms-documentdb-query-iscontinuationexpected
请求标头设置为True,并且请求 确定 .
Set x-ms-documentdb-query-iscontinuationexpected
request header to True, and request is ok.
请捕获您的请求,并检查x-ms-documentdb-query-iscontinuationexpected
请求标头的实际值.
Please capture your request and check the actual value of x-ms-documentdb-query-iscontinuationexpected
request header.
这篇关于DocumentDb-不希望从聚合函数获得完整结果的查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!