[jira] [Created] (ZEPPELIN-93) SparkSQL returning java.lang.NumberFormatException: For input string: "5s"

["Saptak Sen (JIRA)" <ji...@apache.org>]

Saptak Sen created ZEPPELIN-93:
----------------------------------

             Summary: SparkSQL returning java.lang.NumberFormatException: For input string: "5s"
                 Key: ZEPPELIN-93
                 URL: https://issues.apache.org/jira/browse/ZEPPELIN-93
             Project: Zeppelin
          Issue Type: Bug
          Components: Interpreters
    Affects Versions: 0.5.0
         Environment: Spark 1.3.1
            Reporter: Saptak Sen
             Fix For: 0.5.0


#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"




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)