You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Athira Das (JIRA)" <ji...@apache.org> on 2014/08/04 08:41:12 UTC

[jira] [Commented] (SPARK-2820) Group by query not returning random values

    [ https://issues.apache.org/jira/browse/SPARK-2820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14084365#comment-14084365 ] 

Athira Das commented on SPARK-2820:
-----------------------------------

sqlContext.sql("SELECT id, month, AVG(marks) FROM data WHERE marks>25 GROUP BY id, month").
 For this query the  output should be [id_1, 2, 50 ], [id_1, 3, 34], [id_2, 2, 47].. and so on but instead of that i am getting 
the output like this

[1,2,34], [2,2,45] and so on

i am not able to get the id properly instead of that some random values are getting polulated

> Group by query not returning random values
> ------------------------------------------
>
>                 Key: SPARK-2820
>                 URL: https://issues.apache.org/jira/browse/SPARK-2820
>             Project: Spark
>          Issue Type: Question
>            Reporter: Athira Das
>




--
This message was sent by Atlassian JIRA
(v6.2#6252)

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