smallint function
Applies to: 
Databricks SQL Databricks Runtime
Casts the value expr to SMALLINT. This function is a synonym for CAST(expr AS SMALLINT). See cast function for details.
Syntax
smallint(expr)
Arguments
expr: Any expression which is castable toSMALLINT.
Returns
The result is SMALLINT.
If expr is a STRING that cannot be parsed as a number, Databricks raises a CAST_INVALID_INPUT error. If the value overflows the SMALLINT range, Databricks raises a CAST_OVERFLOW error.
Common error conditions
Examples
SQL
> SELECT smallint(-5.6);
5
> SELECT smallint('5');
5
> SELECT smallint('abc');
Error: CAST_INVALID_INPUT