N Campbell created SPARK-10777:
----------------------------------

             Summary: order by fails when column is aliased and projection 
includes windowed aggregate
                 Key: SPARK-10777
                 URL: https://issues.apache.org/jira/browse/SPARK-10777
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 1.5.0
            Reporter: N Campbell


This statement fails in SPARK (works fine in ORACLE, DB2 ....)

select r as c1, min ( s ) over ()  as c2 from
        ( select rnum r, sum ( cint ) s from certstring.tint group by rnum ) t
order by r
Error: org.apache.spark.sql.AnalysisException: cannot resolve 'r' given input 
columns c1, c2; line 3 pos 9
SQLState:  null
ErrorCode: 0

Forcing the aliased column name works around the defect

select r as c1, min ( s ) over ()  as c2 from
        ( select rnum r, sum ( cint ) s from certstring.tint group by rnum ) t
order by c1

These work fine

select r as c1, min ( s ) over ()  as c2 from
        ( select rnum r, sum ( cint ) s from certstring.tint group by rnum ) t
order by c1

select r as c1, s  as c2 from
        ( select rnum r, sum ( cint ) s from certstring.tint group by rnum ) t
order by r


create table  if not exists TINT ( RNUM int , CINT int   )
 ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' 
 STORED AS ORC  ;




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to