typeof
function
Applies to: Databricks SQL Databricks Runtime
Return a DDL-formatted type string for the data type of the input.
Syntax
typeof(expr)
Arguments
expr
: Any expression.
Returns
A STRING
.
To derive the type of a VARIANT
value, use the schema_of_variant function.
To derive the combined schema of a group of VARIANT
values, use the schema_of_variant_agg aggregate function aggregate function.
Examples
> SELECT typeof(1);
int
> SELECT typeof(array(1));
array<int>
> SELECT typeof(123.4::VARIANT);
variant
> SELECT schema_of_variant(123.4::VARIANT);
DECIMAL(4,1)