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 ||
