Mailing-List: contact common-commits-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: common-dev@hadoop.apache.org
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Apache Wiki <wikidiffs@apache.org>
To: core-commits@hadoop.apache.org
Date: Mon, 20 Jul 2009 23:53:59 -0000
Message-ID: <20090720235359.12865.15912@eos.apache.org>
Subject: [Hadoop Wiki] Update of "Hive/Tutorial" by VijendarGanta

Dear Wiki user,

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

The following page has been changed by VijendarGanta:
http://wiki.apache.org/hadoop/Hive/Tutorial

------------------------------------------------------------------------------
  || A IS NULL || all types || TRUE if expression A evaluates to NULL otherwise FALSE||
  || A IS NOT NULL || all types || TRUE if expression A evaluates to NULL otherwise FALSE||
  || 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) while the % character in B matches an arbitrary number of characters in A(similar to .* in posix regular expressions) e.g. 'foobar' like 'foo' evaluates to FALSE where as 'foobar' like {{{'foo___'}}} evaluates to TRUE and so does 'foobar' like 'foo%'||
+ || NOT A LIKE B || strings || TRUE if string A matches the SQL simple regular expression B, otherwise FALSE||
  || 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 e.g. 'foobar' rlike 'foo' evaluates to FALSE where as 'foobar' rlike '^f.*r$' evaluates to TRUE||
  || A REGEXP B || strings || Same as RLIKE ||