Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5512

Wrong SELECT syntax documentation

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Impala 2.9.0
    • Component/s: Docs
    • Labels:
    • Epic Color:
      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]
      ...
      

        Attachments

          Activity

            People

            • Assignee:
              jrussell John Russell
              Reporter:
              lukas.eder Lukas Eder
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: