You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@spark.apache.org by Ravisankar Mani <rr...@gmail.com> on 2015/07/10 06:40:26 UTC

Performance slow

Hi everyone,

            More time to be taken when i execute query using  (group by +
order by) or (group by + cast + order by)   in same query. Kindly refer the
following query

Could you please provide any solution regarding thisd performance issue?



SELECT If(ISNOTNULL(SUM(CAST(adventurepersoncontacts.contactid AS
decimal(38,6)))),SUM(CAST(adventurepersoncontacts.contactid AS
decimal(38,6))),0) AS adventurepersoncontacts_contactid,
adventurepersoncontacts.fullname as adventurepersoncontacts_fullname FROM
default.adventurepersoncontacts AS adventurepersoncontacts order by
adventurepersoncontacts.fullname asc

Regards,
Ravisankar M R