Re: sql: how to convert datatype of column?

raela · ‎03-08-2016

@dan11

We don't support

number

in Spark SQL. Try using

int

,

double

,

float

, and your query should be fine. To run SQL in a notebook, just prepend any cell with %sql.

%sql
select cast(myage as double) as my_integer_age from ages;