I am not sure whether this can be possible but i have tried something like
SELECT time, src, dst, sum(val1), sum(val2) from table group by
src,dst;
and it works.I think it will result the same answer as you are expecting
--
View this message in context:
http://apache-spark-user-lis
Not so sure your intention, but something like "SELECT sum(val1), sum(val2)
FROM table GROUP BY src, dest" ?
-Original Message-
From: Shailesh Birari [mailto:sbirar...@gmail.com]
Sent: Friday, March 20, 2015 9:31 AM
To: user@spark.apache.org
Subject: Spark SQL Self join with agreegate