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/09/18 11:10:04 UTC

[jira] [Created] (SPARK-10690) SQL select count(distinct ) won't work for a normal load

Dave created SPARK-10690:
----------------------------

             Summary: 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