Unable to use PhaseCounts.Fetch in N1QL

SQL++
1

I am getting below error if I use .Fetch attribute in SELECT/WHERE clause
{
“code”: 3000,
“msg”: “syntax error - at Fetch”,
“query_from_user”: “SELECT * FROM system:completed_requests WHERE ElapsedTime > “8” AND PhaseCounts.Fetch IS NOT MISSING;”
}

But the query runs fine for PhaseCounts.IndexScan and PhaseCounts.Sort attributes. I am not sure why PhaseCounts.Fetch is not allowed in N1QL

Any help would really appreciated

Thanks and Regards,
Shankar Hendre

2

Use back tick around fetch

SELECT * FROM system:completed_requests WHERE ElapsedTime > “8” AND phaseCounts.`fetch` IS NOT MISSING;

3

Anytime you need to use a reserved word as an attribute, use backquote around them to differentiate.

4

Thanks a lot Keshav… Really appreciate it…