spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ravisankar Mani <>
Subject Performance slow
Date Fri, 10 Jul 2015 04:40:26 GMT
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

Ravisankar M R

View raw message