Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-2709

Semantic Analysis failed for GroupBy query with aliase.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 0.8.0
    • None
    • SQL
    • None

    • SuSE11 SP1

    Description

      In the SQL ,

      "select empno from test t group by t.empno"

      type of query work fine where as in hive ,below exception

      "org.apache.hadoop.hive.ql.parse.SemanticException: line 1:7 Expression Not In Group By Key ename".

      For the above, column_name with aliase work fine i.e

      "select t.empno from test t group by t.empno" is work fine.

      Attachments

        1. ASF.LICENSE.NOT.GRANTED--HIVE-2709.D1305.2.patch
          38 kB
          Phabricator
        2. ASF.LICENSE.NOT.GRANTED--HIVE-2709.D1305.1.patch
          38 kB
          Phabricator
        3. HIVE-2709.1.patch.txt
          2 kB
          Navis Ryu

        Activity

          People

            Unassigned Unassigned
            rohithsharma Rohith Sharma K S
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: