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