longRound
Round a column value by parameter.
Round column value by the roundValue parameter.
Usage Details
select *, longRound(column, roundValue) as roundValue from table
-- column: column in the table to apply UDF
-- roundValue: parameter to round column value
-- roundValue: output of UDF, rounded, e.g.
-- Example
-- table with "port" field and values = 1223
select longRound(col, 100) as roundVal from table
-- will return 1200 for roundVal
Updated 6 months ago