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

Table aliases in order by clause lead to semantic analysis failure

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Query Processor
    • Labels:
      None

      Description

      A simple statement of the form

      select a.account_id, count(1) from tmp_ash_test2 a group by a.account_id order by a.account_id;

      throws a sematic analysis exception

      where as

      select a.account_id, count(1) from tmp_ash_test2 a group by a.account_id order by account_id;

      works fine (the second query does not have the table alias a in the order by clause.

        Attachments

          Activity

            People

            • Assignee:
              athusoo Ashish Thusoo
              Reporter:
              athusoo Ashish Thusoo
            • Votes:
              2 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated: