hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/Tutorial" by VijendarGanta
Date Wed, 02 Jun 2010 18:04:36 GMT
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 ||
  

Mime
View raw message