Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
0.5.0
-
None
-
Spark 1.3.1
-
Important
Description
#When I run this from Zeppelin:
case class Health (year: String, state: String, category:String, funding_src1: String, funding_scr2: String, spending: Integer)
val health = dataset.map(k=>k.split(",")).map(
k => Health(k(0),k(1),k(2),k(3), k(4), k(5).toInt)
)
health.setName("health_table")
%sql
select state, sum(spending)/1000 SpendinginBillions
from health_table
group by state
order by SpendinginBillions desc
#I get the following error:
java.lang.NumberFormatException: For input string: "5s"