| ARRAY_TO_STRING | Returns a string of the values from the input array, with the values separated by the specified delimiter string. |
| BINARY_STRING | Converts the input expression to a binary value. |
| CAST | Converts a value of one data type to another data type. This function behaves similarly to the TO_<data_type> (i.e. TO_TIMESTAMP) functions. |
| CONVERT_FROM | Converts a binary string from the given data type to a Dremio type. |
| CONVERT_REPLACEUTF8 | Converts a binary string to a UTF-8 value and replaces all characters that cannot be converted to UTF-8 with the specified replacement character. |
| CONVERT_TIMEZONE | Convert timestamp to the specified timezone. |
| CONVERT_TO | Converts a value to a binary string of a supported data type. |
| ENCODE | Encodes the input expression using the specified charSet character encoding. |
| FROM_HEX | Returns a binary value for the given hexadecimal string. |
| HASH | Returns a hash value of the arguments. HASH does not return NULL, even for NULL inputs. |
| HASH64 | Returns 64-bit hash of input value, with optional seed. |
| HEX | Returns the hexadecimal encoding of an expression. |
| STRING_BINARY | Returns a string that represents the provided bytes. Escapes non-printable characters as hex values. |
| ST_FROMGEOHASH | Returns the latitude and longitude coordinates of the center of the given geohash. |
| ST_GEOHASH | Returns the corresponding geohash for the given latitude and longitude coordinates. |
| TOASCII | Converts a string that is encoded in the specified character set to UTF-8. |
| TO_CHAR | Converts the input expression to a character/string using the specified format. |
| TO_DATE | Converts the input expressions to the corresponding date. |
| TO_HEX | Returns a hexadecimal string for the given binary value. |
| TO_NUMBER | Converts a string into a number (double) in the specified format. |
| TO_TIME | Converts the input expressions to the corresponding time. |
| TO_TIMESTAMP | Converts the input expressions to the corresponding timestamp. |
| TRY_CONVERT_FROM | Attempts to convert a JSON string to a data type supported in Dremio. |
| UNHEX | Converts the hexadecimal number into the bytes represented by a number. |