[
https://issues.apache.org/jira/browse/SPARK-10690?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14876215#comment-14876215
]
Yin Huai commented on SPARK-10690:
----------------------------------
This problem should be fixed in 1.5. Can you try it?
> SQL select count(distinct ) won't work for a normal load
> --------------------------------------------------------
>
> Key: SPARK-10690
> URL: https://issues.apache.org/jira/browse/SPARK-10690
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.4.1
> Reporter: Dave
>
> I have about 200million email records. Spark 1.4.1 running with
> --num-executors=5 --executor-cores=3
> --executor-memory=20g
> The set up more than enough for doing a distinct and count but when I do
> select count(distinct email) from theTable
> I always got the error that some executors are lost.
> If I do
> select count(*) from (select distinct email from theTable) tmp
> then it works.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
