Spark SQL - groupby

[Subacini B]

Hi,

Below code throws  compilation error , "not found: *value Sum*" . Can
someone help me on this. Do i need to add any jars or imports ? even for
Count , same error is thrown

val queryResult = sql("select * from Table)
     queryResult.groupBy('colA)('colA,*Sum*('colB) as 'totB).aggregate(*Sum*
('totB)).collect().foreach(println)

Thanks
subacini