Miscellaneous functions

Preview Spark miscellaneous functions in SparkSQL and Databricks compatibility modes. Both modes share these functions. Support is one of: Supported, With limitations, or Not supported. Supported means every example in the Spark reference returns what Spark returns; a note under With limitations quotes a call that differs.

Function	Support	Notes
`UUID`	Supported
`CURRENT_CATALOG`	With limitations	Returns the current Firebolt database, where Spark returns `spark_catalog`.
`CURRENT_DATABASE`	With limitations	Returns the current Firebolt database, where Spark returns the current schema.
`CURRENT_SCHEMA`	With limitations	Returns the current Firebolt schema, `public` unless set otherwise.
`CURRENT_USER`	With limitations	Returns the Firebolt user name.
`SESSION_USER`	With limitations	Returns the Firebolt user name.
`TYPEOF`	With limitations	`typeof(1)` returns `'integer'`, where Spark returns `'int'`.
`USER`	With limitations	Returns the Firebolt user name.
`VERSION`	With limitations	Returns Firebolt’s version string.
`AES_DECRYPT`, `AES_ENCRYPT`, `APPROX_TOP_K_ESTIMATE`, `ASSERT_TRUE`, `BITMAP_BIT_POSITION`, `BITMAP_BUCKET_NUMBER`, `BITMAP_COUNT`, `FROM_AVRO`, `FROM_PROTOBUF`, `HLL_SKETCH_ESTIMATE`, `HLL_UNION`, `INPUT_FILE_BLOCK_LENGTH`, `INPUT_FILE_BLOCK_START`, `INPUT_FILE_NAME`, `JAVA_METHOD`, `KLL_SKETCH_GET_N_BIGINT`, `KLL_SKETCH_GET_N_DOUBLE`, `KLL_SKETCH_GET_N_FLOAT`, `KLL_SKETCH_GET_QUANTILE_BIGINT`, `KLL_SKETCH_GET_QUANTILE_DOUBLE`, `KLL_SKETCH_GET_QUANTILE_FLOAT`, `KLL_SKETCH_GET_RANK_BIGINT`, `KLL_SKETCH_GET_RANK_DOUBLE`, `KLL_SKETCH_GET_RANK_FLOAT`, `KLL_SKETCH_MERGE_BIGINT`, `KLL_SKETCH_MERGE_DOUBLE`, `KLL_SKETCH_MERGE_FLOAT`, `KLL_SKETCH_TO_STRING_BIGINT`, `KLL_SKETCH_TO_STRING_DOUBLE`, `KLL_SKETCH_TO_STRING_FLOAT`, `MONOTONICALLY_INCREASING_ID`, `RAISE_ERROR`, `REFLECT`, `SCHEMA_OF_AVRO`, `SPARK_PARTITION_ID`, `THETA_DIFFERENCE`, `THETA_INTERSECTION`, `THETA_SKETCH_ESTIMATE`, `THETA_UNION`, `TO_AVRO`, `TO_PROTOBUF`, `TRY_AES_DECRYPT`, `TRY_REFLECT`	Not supported

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal