Module datafusion::functions::expr_fn

Fluent-style API for creating Exprs

Functions

• abs
  returns the absolute value of a given number Return $name(arg)
• acos
  returns the arc cosine or inverse cosine of a number Return $name(arg)
• arrow_cast
  returns arg_1 cast to the arrow_type given the second argument. This can be used to cast to a specific arrow_type. Return $name(arg)
• arrow_typeof
  Returns the Arrow type of the input expression. Return $name(arg)
• ascii
  Returns the numeric code of the first character of the argument.
• asin
  returns the arc sine or inverse sine of a number Return $name(arg)
• bit_length
  Returns the number of bits in the string
• btrim
  Removes all characters, spaces by default, from both sides of a string
• char_length
  the number of characters in the string
• character_length
  the number of characters in the string
• chr
  Converts the Unicode code point to a UTF8 character
• current_date
  returns current UTC date as a Date32 value
• current_time
  returns current UTC time as a Time64 value
• date_bin
  coerces an arbitrary timestamp to the start of the nearest specified interval
• date_part
  extracts a subfield from the date
• date_trunc
  truncates the date to a specified level of precision
• decode
  decode the input, using the encoding. encoding can be base64 or hex Return $name(arg)
• digest
  Computes the binary hash of an expression using the specified algorithm. Return $name(arg)
• encode
  encode the input, using the encoding. encoding can be base64 or hex Return $name(arg)
• from_unixtime
  converts an integer to RFC3339 timestamp format string
• get_field
  Returns the value of the field with the given name from the struct Return $name(arg)
• isnan
  returns true if a given number is +NaN or -NaN otherwise returns false Return $name(arg)
• length
  the number of characters in the string
• levenshtein
  Returns the Levenshtein distance between the two given strings
• lower
  Converts a string to lowercase.
• ltrim
  Removes all characters, spaces by default, from the beginning of a string
• make_date
  make a date from year, month and day component parts
• md5
  Computes an MD5 128-bit checksum for a string expression. Return $name(arg)
• now
  returns the current timestamp in nanoseconds, using the same value for all instances of now() in same statement
• nullif
  returns NULL if value1 equals value2; otherwise it returns value1. This can be used to perform the inverse operation of the COALESCE expression. Return $name(arg)
• nvl
  returns value2 if value1 is NULL; otherwise it returns value1 Return $name(arg)
• nvl2
  Returns value2 if value1 is not NULL; otherwise, it returns value3. Return $name(arg)
• octet_length
  returns the number of bytes of a string
• overlay
  replace the substring of string that starts at the start’th character and extends for count characters with new substring
• regexp_like
  Returns true if a has at least one match in a string,false otherwise. Return $name(arg)
• regexp_match
  returns a list of regular expression matches in a string. Return $name(arg)
• regexp_replace
  Replaces substrings in a string that match Return $name(arg)
• repeat
  Repeats the string to n times
• replace
  Replaces all occurrences of from with to in the string
• rtrim
  Removes all characters, spaces by default, from the end of a string
• sha224
  Computes the SHA-224 hash of a binary string. Return $name(arg)
• sha256
  Computes the SHA-256 hash of a binary string. Return $name(arg)
• sha384
  Computes the SHA-384 hash of a binary string. Return $name(arg)
• sha512
  Computes the SHA-512 hash of a binary string. Return $name(arg)
• split_part
  Splits a string based on a delimiter and picks out the desired field based on the index.
• starts_with
  Returns true if string starts with prefix.
• struct
  Returns a struct with the given arguments Return $name(arg)
• tan
  returns the tangent of a number Return $name(arg)
• tanh
  returns the hyperbolic tangent of a number Return $name(arg)
• to_char
  Returns a string representation of a date, time, timestamp or duration based on a Chrono pattern.
• to_date
• to_hex
  Converts an integer to a hexadecimal string.
• to_timestamp
  converts a string and optional formats to a Timestamp(Nanoseconds, None)
• to_timestamp_micros
  converts a string and optional formats to a Timestamp(Microseconds, None)
• to_timestamp_millis
  converts a string and optional formats to a Timestamp(Milliseconds, None)
• to_timestamp_nanos
  converts a string and optional formats to a Timestamp(Nanoseconds, None)
• to_timestamp_seconds
  converts a string and optional formats to a Timestamp(Seconds, None)
• to_unixtime
  converts a string and optional formats to a Unixtime
• trim
  Removes all characters, spaces by default, from both sides of a string
• upper
  Converts a string to uppercase.
• uuid
  returns uuid v4 as a string value