Hive
  1. Hive
  2. HIVE-1449

Table aliases in order by clause lead to semantic analysis failure

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major 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.

        Activity

        Ashish Thusoo created issue -
        Carl Steinbach made changes -
        Field Original Value New Value
        Fix Version/s 0.7.0 [ 12315150 ]

          People

          • Assignee:
            Ashish Thusoo
            Reporter:
            Ashish Thusoo
          • Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

            • Created:
              Updated:

              Development