Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Usage details

LQL

select *, toIntArray(column) as intArrayColumn from tableName

Input parameters:
column: An array column

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

Example

Input Table: input_table

column

WrappedArray("3.45", "15")

WrappedArray("178.90", "-45.78")

LQL

select *, toIntArray(column) as intArrayColumn from input_table

Ouput:

column

intArrayColumn

WrappedArray("3.45", "15")

WrappedArray(3, 15)

WrappedArray("178.90", "-45.78")

WrappedArray(178, -45)

  • No labels