On this page

    Conversion

    Function NameDescription
    BINARY_STRINGConverts the input expression to a binary value.
    CASTConverts 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_FROMConverts a binary string from the given data type to a Dremio type.
    CONVERT_REPLACEUTF8Converts 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_TIMEZONEConvert timestamp to the specified timezone
    CONVERT_TOConverts a value to a binary string of a supported data type.
    FLATTENExplodes compound values into multiple rows. This function takes a LIST column and produces a lateral view (that is, an inline view that contains correlation referring to other tables that precede it in the FROM clause).
    FROM_HEXReturns a binary value for the given hexadecimal string
    HASHReturns a hash value of the arguments. HASH does not return NULL, even for NULL inputs.
    TOASCIIConverts a string that is encoded in the specified character set to UTF-8.
    TO_CHARConverts the input expression to a character/string using the specified format.
    TO_DATEConverts the input expressions to the corresponding date.
    TO_HEXReturns a hexadecimal string for the given binary value.
    TO_NUMBERConverts a string into a number (double) in the specified format.
    TO_TIMEConverts the input expressions to the corresponding time.
    TO_TIMESTAMPConverts the input expressions to the corresponding timestamp.