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