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)