You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Michael Armbrust (JIRA)" <ji...@apache.org> on 2015/08/03 21:14:05 UTC

[jira] [Resolved] (SPARK-9444) RemoveEvaluationFromSort reorders sort order

     [ https://issues.apache.org/jira/browse/SPARK-9444?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Armbrust resolved SPARK-9444.
-------------------------------------
    Resolution: Duplicate

> RemoveEvaluationFromSort reorders sort order
> --------------------------------------------
>
>                 Key: SPARK-9444
>                 URL: https://issues.apache.org/jira/browse/SPARK-9444
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>            Reporter: Michael Armbrust
>            Assignee: Wenchen Fan
>            Priority: Blocker
>
> {code}
> Seq((1,2,3,4)).toDF("a", "b", "c", "d").registerTempTable("test")
> scala> sqlContext.sql("SELECT * FROM test ORDER BY a + 1, b").queryExecution
> == Parsed Logical Plan ==
> 'Sort [('a + 1) ASC,'b ASC], true
>  'Project [unresolvedalias(*)]
>   'UnresolvedRelation [test], None
> == Optimized Logical Plan ==
> Project [a#4,b#5,c#6,d#7]
>  Sort [b#5 ASC,_sortCondition#9 ASC], true
>   LocalRelation [a#4,b#5,c#6,d#7,_sortCondition#9], [[1,2,3,4,2]]
> {code}
> Notice how we are now sorting by b before a + 1.



--
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