[Hadoop Wiki] Update of "Hive/Tutorial" by VijendarGanta

[Apache Wiki <wi...@apache.org>]

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