You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Dave (JIRA)" <ji...@apache.org> on 2015/10/30 00:02:27 UTC
[jira] [Commented] (SPARK-10690) SQL select count(distinct ) won't
work for a normal load
[ https://issues.apache.org/jira/browse/SPARK-10690?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14981527#comment-14981527 ]
Dave commented on SPARK-10690:
------------------------------
just installed 1.5.1 and verified it works.
> 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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org