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

Support GROUP/ORDER BY column references by ordinal position

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Duplicate
    • None
    • None
    • SQL
    • None

    Description

      Allow user to reference the group by or order by column by the desired column's ordinal position

      Support syntax such as:

      select t.col1, sum(t.col2) from my_table t group by 1 order by 1

      Attachments

        Issue Links

          Activity

            People

              hagleitn Gunther Hagleitner
              jtschei John Scheibmeir
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: