topic sql: how to convert datatype of column? in Data Engineering

sql: how to convert datatype of column?

dan11 — Mon, 07 Mar 2016 23:05:49 GMT

Bricklayers,
I want to port this sql statement from sqlite to databricks:
select cast(myage as number) as my_integer_age from ages;
Does databricks allow me to do something like this?

Re: sql: how to convert datatype of column?

raela — Tue, 08 Mar 2016 19:21:03 GMT

@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;