[
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: [email protected]
For additional commands, e-mail: [email protected]
