Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
None
-
ghx-label-7
Description
The documentation specifies two times GROUP BY, when the latter should be ORDER BY:
https://www.cloudera.com/documentation/enterprise/5-8-x/topics/impala_select.html#select
IS:
...
WHERE conditions
GROUP BY { column | expression [ASC | DESC] [NULLS FIRST | NULLS LAST] [, ...] }
HAVING conditions
GROUP BY { column | expression [ASC | DESC] [, ...] }
LIMIT expression [OFFSET expression]
...
SHOULD BE:
...
WHERE conditions
GROUP BY { column | expression [ASC | DESC] [NULLS FIRST | NULLS LAST] [, ...] }
HAVING conditions
ORDER BY { column | expression [ASC | DESC] [, ...] }
LIMIT expression [OFFSET expression]
...