Document toolboxDocument toolbox

toDoubleArray

Owned by Jonas Gonzalez
Nov 29, 2024
1 min read
[ 1 Usage Details ] [ 2 Example ]

Usage Details

LQL

select *, toDoubleArray(column) as doubleArrayColumn from tableName

Input Parameters:
column: An array column

Output:
A column doubleArrayColumn which is same as column but each element in each row casted to double data type.

Example

Input Table: input_table

column

column

WrappedArray("3.45", "15")

WrappedArray("178.90", "-45.78")

LQL

select *, toDoubleArray(column) as doubleArrayColumn from input_table

Ouput:

column

doubleArrayColumn

column

doubleArrayColumn

WrappedArray("3.45", "15")

WrappedArray(3.45, 15)

WrappedArray("178.90", "-45.78")

WrappedArray(178.90, -45.78)