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. substr('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', 4) 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 || substr(string A, int start, int length) || returns the substring of A starting from start position with the given length e.g. substr('foobar', 4, 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'||
