Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: move anchors before heading text "Operators Precedences" to improve incoming links

...

Note
titleBug for expression caching when UDF nested in UDF or function

When hive.cache.expr.evaluation is set to true (which is the default) a UDF can give incorrect results if it is nested in another UDF or a Hive function. This bug affects releases 0.12.0, 0.13.0, and 0.13.1. Release 0.14.0 fixed the bug (HIVE-7314).

The problem relates to the UDF's implementation of the getDisplayString method, as discussed in the Hive user mailing list.

Built-in Operators

...

Anchor
Operators precedences
Operators precedences
Anchor
Operators Precedences
Operators Precedences
Operators Precedences

Example

Operators

Description

A[B] , A.identifierbracket_op([]), dot(.)element selector, dot

-A

unary(+), unary(-), unary(~)

unary prefix operators

A IS (NOT) NULLIS NULL,IS NOT NULLunary suffix

A ^ B

bitwise xor(^)

bitwise xor

A * Bstar(*), divide(/), mod(%), div(DIV)multiplicative operators
A + Bplus(+), minus(-)

additive operators

A || Bstring concatenate(||)string concatenate
A & Bbitwise and(&)bitwise and
A | Bbitwise or(|)bitwise or

...