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

Group By Operator doesn't carry forward table aliases in its RowResolver

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • None
    • 0.13.0
    • Query Processor
    • None

    Description

      The following queries fails:

      select b.key, count(*) from src b group by key
      select key, count(*) from src b group by b.key
      

      with a SemanticException; the select expression b.key (key in the 2nd query) are not resolved by the GBy RowResolver.

      This is because the GBy RowResolver only supports resolving based on an AST.toStringTree match. Underlying issue is that a RowResolver doesn't allow multiple mappings to the same ColumnInfo.

      Attachments

        1. HIVE-5784.1.patch
          30 kB
          Harish Butani

        Activity

          People

            rhbutani Harish Butani
            rhbutani Harish Butani
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: