[Couchbase Forums] [Java SDK] Couchbase JAVA SDK 2.2.5 Order by showing sortCount is 0

Hi Todd/Cihan,
This looks like SDK issue. Can you pls check/confirm. Apparently, the N1qlMetrics Object has SortCount 0.

https://forums.couchbase.com/t/couchbase-java-sdk-2-2-5-order-by-showing-sortcount-is-0/8246
Select name from default where name is not missing and CONTAINS(name,'for') order by name LIMIT 30 OFFSET 0

N1qlMetrics

{, resultCount=30, errorCount=0, warningCount=0, mutationCount=0, sortCount=0, resultSize=1658, elapsedTime='7.0034ms', executionTime='7.0034ms'}

Even if i use order by sortCount is showing

Thanks,

-Prasad

From: Gerald Sangudi <Gerald@couchbase.com>
Date: Sunday, May 15, 2016 at 9:53 AM
To: Cihan Biyikoglu <cihan@couchbase.com>, Prasad Varakur <prasad.varakur@couchbase.com>
Cc: Keshav Murthy <keshav@couchbase.com>
Subject: FW: [Couchbase Forums] [Java SDK] Couchbase JAVA SDK 2.2.5 Order by showing sortCount is 0

Hi Cihan, Prasad,

Please see below. The SDKs should not be modifying the response from Query. In the example below, the SDK is adding sortCount even though Query did not provide it.

Not to get into details: This is the equivalent of FedEx deciding to open an Amazon shipment and add batteries, because FedEx decided that this particular toy should ship with batteries. It is hard to believe.

Please work it out with them and handle this user. By the way, this kind of system development is not sustainable.

Thanks,
Gerald

From: Krishnasahu2016 <forums@couchbase.com>
Reply-To: Couchbase Forums <reply+22f76bc256e0b9e3c47efb3342993073@forummail.couchbase.com>
Date: Sunday, May 15, 2016 at 9:37 AM
To: Gerald Sangudi <gerald@couchbase.com>
Subject: [Couchbase Forums] [Java SDK] Couchbase JAVA SDK 2.2.5 Order by showing sortCount is 0

krishnasahu2016 krishnasahu2016
May 15
Please find explain

[
{
"plan": {
"#operator": "Sequence",
"~children": [
{
"#operator": "Sequence",
"~children": [
{
"#operator": "IndexScan",
"covers": [
"cover ((default.name))",
"cover ((meta(default).id))"
],
"index": "index_name_array",
"index_id": "c0b57eaa81c4e3d",
"keyspace": "default",
"limit": "(0 + 30)",
"namespace": "default",
"spans": [
{
"Range":

{ "Inclusion": 0, "Low": [ "null" ] }

}
],
"using": "gsi"
},
{
"#operator": "Parallel",
"maxParallelism": 1,
"~child": {
"#operator": "Sequence",
"~children": [

{ "#operator": "Filter", "condition": "((cover ((default.name)) is not missing) and contains(cover ((default.name)), \"for\"))" }

,
{
"#operator": "InitialProject",
"result_terms": [

{ "expr": "cover ((meta(default).id))" }

]
}
]
}
}
]
},

{ "#operator": "Offset", "expr": "0" }

,

{ "#operator": "Limit", "expr": "30" }

,

{ "#operator": "FinalProject" }

]
},
"text": "Select META().id from default where name is not missing and CONTAINS(name,'for') order by name LIMIT 30 OFFSET 0"
}
]

Visit Topic or reply to this email to respond

In Reply To

geraldss geraldss
May 14
Hi @krishnasahu2016 Please post the EXPLAIN output for this query.
Visit Topic or reply to this email to respond

To stop receiving notifications for this particular topic, click here. To unsubscribe from these emails, change your user preferences