Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Trivial edits for cast(). By the way, what does "Expected = ..." mean for the Return Type? (It's been there from the start.)

...

Return Type

Name(Signature)

Description

binary

binary(string|binary)

Casts the parameter into a binary.

Expected "=" to follow "type"

cast(expr as <type>)

Converts the results of the expression expr to <type>. For example, cast('1' as BIGINT) will convert the string '1' to its integral representation. A null is returned if the conversion does not succeed. If cast(exp expr as boolean) hive Hive returns true for a non-empty string.

Date Functions

...