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] [Issue Comment Deleted] (SPARK-2820) Group by query not
returning random values
[ https://issues.apache.org/jira/browse/SPARK-2820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Athira Das updated SPARK-2820:
------------------------------
Comment: was deleted
(was: 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
>
> 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
--
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