Note: Requires testcase to force select order by aliases a, b, c and so on This is needed to correlate order from n1ql results and GSI scan Ex: SELECT Year as a, Month as b, SUM(Sale) as c from default GROUP BY Year, Month Also, this re-reduces partial results from GSI and forms collapsed result set.