You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by Apache Wiki <wi...@apache.org> on 2009/02/27 14:54:33 UTC

[Hadoop Wiki] Update of "Hive/Tutorial" by Sancar Gazi

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