Hive Built-in Functions in Big Data Hadoop

BIGINT   round(double a)

BIGINT   floor(double a)

BIGINT   ceil(double a)  

double   rand(), rand(int seed)

string   concat(string A,

string   substr(string A,

string   substr(string A,

string   upper(string A)

string   ucase(string A)

string   lower(string A)

string   lcase(string A)

string   trim(string A)  

string   ltrim(string A)

string   rtrim(string A)