[jira] [Created] (IMPALA-9018) ORDER BY using an expression + column alias fails with "Could not resolve column/field"

["Greg Rahn (Jira)" <ji...@apache.org>]

Greg Rahn created IMPALA-9018:
---------------------------------

             Summary: ORDER BY using an expression + column alias fails with "Could not resolve column/field"
                 Key: IMPALA-9018
                 URL: https://issues.apache.org/jira/browse/IMPALA-9018
             Project: IMPALA
          Issue Type: Bug
          Components: Frontend
            Reporter: Greg Rahn
            Assignee: Shant Hovsepian


Test case:

{noformat}
select version();

+-----------------------------------------------------------------------------------------+
| version()                                                                               |
+-----------------------------------------------------------------------------------------+
| impalad version 3.4.0-SNAPSHOT RELEASE (build f047e967d099119717d1d3bbb7a235554707513f) |
| Built on Mon Oct  7 10:07:27 UTC 2019                                                   |
+-----------------------------------------------------------------------------------------+

-- works
with t as (select a from (values(1 as a),(2),(3)) t)
select
  a, 
  a + 10 as alias_of_a
from t
order by abs(a);

+---+------------+
| a | alias_of_a |
+---+------------+
| 1 | 11         |
| 2 | 12         |
| 3 | 13         |
+---+------------+

-- fails with 
-- AnalysisException: Could not resolve column/field reference: 'alias_of_a'
with t as (select a from (values(1 as a),(2),(3)) t)
select
  a, 
  a + 10 as alias_of_a
from t
order by abs(alias_of_a);

{noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)