Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The "Hive/Tutorial" page has been changed by VijendarGanta. http://wiki.apache.org/hadoop/Hive/Tutorial?action=diff&rev1=26&rev2=27 -------------------------------------------------- ||A >= B ||all primitive types ||TRUE if expression A is greater than or equal to expression B otherwise FALSE || ||A IS NULL ||all types ||TRUE if expression A evaluates to NULL otherwise FALSE || ||A IS NOT NULL ||all types ||FALSE if expression A evaluates to NULL otherwise TRUE || - ||A LIKE B ||strings ||TRUE if string A matches the SQL simple regular expression B, otherwise FALSE. The comparison is done character by character. The _ character in B matches any character in A (similar to . in posix regular expressions), and the % character in B matches an arbitrary number of characters in A (similar to .* in posix regular expressions). For example, 'foobar' like 'foo' evaluates to FALSE where as 'foobar' like {{{'foo___'}}} evaluates to TRUE and so does 'foobar' like 'foo%' || + ||A LIKE B ||strings ||TRUE if string A matches the SQL simple regular expression B, otherwise FALSE. The comparison is done character by character. The _ character in B matches any character in A (similar to . in posix regular expressions), and the % character in B matches an arbitrary number of characters in A (similar to .* in posix regular expressions). For example, 'foobar' like 'foo' evaluates to FALSE where as 'foobar' like {{{'foo___'}}} evaluates to TRUE and so does 'foobar' like 'foo%'. To escape % use \ (\% matches one % character) || ||A RLIKE B ||strings ||TRUE if string A matches the Java regular expression B (See [[http://java.sun.com/j2se/1.4.2/docs/api/java/util/regex/Pattern.html|Java regular expressions syntax]]), otherwise FALSE. For example, 'foobar' rlike 'foo' evaluates to FALSE whereas 'foobar' rlike '^f.*r$' evaluates to TRUE || ||A REGEXP B ||strings ||Same as RLIKE ||
