You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Xiao Li (JIRA)" <ji...@apache.org> on 2016/01/17 07:12:39 UTC
[jira] [Commented] (SPARK-10777) order by fails when column is
aliased and projection includes windowed aggregate
[ https://issues.apache.org/jira/browse/SPARK-10777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15103604#comment-15103604 ]
Xiao Li commented on SPARK-10777:
---------------------------------
[~kevinyu98] My PR https://github.com/apache/spark/pull/10678 also resolves this issue. Thanks!
> 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org