You are viewing a plain text version of this content. The canonical link for it is here.

Posted to common-commits@hadoop.apache.org by Apache Wiki <wi...@apache.org> on 2010/06/26 01:25:38 UTC

[Hadoop Wiki] Update of "Hive/LanguageManual/UDF" by PaulYang

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.

The "Hive/LanguageManual/UDF" page has been changed by PaulYang.
http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF?action=diff&rev1=41&rev2=42

--------------------------------------------------

  
  
  === Logical Operators ===
- The following operators provide support for creating logical expressions. All of them return boolean TRUE or FALSE depending upon the boolean values of the operands.
+ The following operators provide support for creating logical expressions. All of them return boolean TRUE, FALSE, or NULL depending upon the boolean values of the operands. 
+ 
  ||<10%>'''Operator''' ||<10%>'''Operand types''' ||'''Description''' ||
  ||A AND B ||boolean ||TRUE if both A and B are TRUE, otherwise FALSE ||
  ||A && B ||boolean ||Same as A AND B ||
  ||A OR B ||boolean ||TRUE if either A or B or both are TRUE, otherwise FALSE ||
  ||A | | B ||boolean ||Same as A OR B ||
- ||NOT A ||boolean ||TRUE if A is FALSE, otherwise FALSE ||
+ ||NOT A ||boolean ||TRUE if A is FALSE or NULL if A is NULL. Otherwise FALSE. ||
  ||! A ||boolean ||Same as NOT A ||