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 Sancar Gazi
Date Fri, 27 Feb 2009 13:54:33 GMT
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 Sancar Gazi:
http://wiki.apache.org/hadoop/Hive/Tutorial

------------------------------------------------------------------------------
  || BIGINT || ceil(double a) || returns the minimum BIGINT value that is equal or greater
than the double||
  || double || rand(), rand(int seed) || returns a random number (that changes from row to
row). Specifiying the seed will make sure the generated random number sequence is deterministic.||
  || string || concat(string A, string B)|| returns the string resulting from concatenating
B after A e.g. concat('foo', 'bar') results in 'foobar'||
- || string || substr(string A, int start) || returns the substring of A starting from start
position till the end of string A e.g. concat('foobar', 3) results in 'bar'||
+ || string || substr(string A, int start) || returns the substring of A starting from start
position till the end of string A e.g. substr('foobar', 3) results in 'bar'||
+ || string || substr(string A, int start, int length) || returns the substring of A starting
from start position with the given length e.g. substr('foobar', 3, 2) results in 'ba'||
  || string || upper(string A)|| returns the string resulting from converting all characters
of A to upper case e.g. upper('fOoBaR') results in 'FOOBAR'||
  || string || ucase(string A) || Same as upper||
  || string || lower(string A) || returns the string resulting from converting all characters
of B to lower case e.g. lower('fOoBaR') results in 'foobar'||

Mime
View raw message