Hive常用函数有哪些

1524990177 • 09/13 10:10 • Linux技术 • 83 views

小编给大家分享一下Hive常用函数有哪些，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！数学函数
round(double d)round(double d,int n)floor(double d)ceil(double d)ceiling(double d)rand()rand(int seed)exp(double d)ln(double d)log10(double d)log2(double d)log(double base,double d)pow(double d,double p)power(double d,double p)sqrt(double d)hex(bigint i) 香港云主机hex(string str)abs(double d)PI()

集合函数
size(Map)map_keys(Map)map_values(Map)array_contains(Array, value)sort_array(Array)
类型转换函数
cast(expr as )
日期函数
date_adddate_subnext_daylast_dayfrom_unixtime(bigint unixtime, string format)to_date(string timestamp)year(string date)month(string date)hour(string date)weekofyear(string date)datediff(string enddate, string startdate)add_months(string start_date, int num_months)date_format(date/timestamp/string ts, string fmt)
条件函数
if(boolean testCondition, T valueTrue, T valueFalseOrNull)nvl(T value, T default_value)COALESCE(T v1, T v2, …)CASE a WHEN b THEN c [WHEN d THEN e]* [ELSE f] ENDisnull( a )isnotnull ( a )
字符函数
concat(string|binary A, string|binary B…)concat_ws(string SEP, string A, string B…)length(string A)
lower(string A) lcase(string A)parse_url(string urlString, string partToExtract [, string keyToExtract])regexp_replace(string INITIAL_STRING, string PATTERN, string REPLACEMENT)reverse(string A)split(string str, string pat)substr(string|binary A, int start) substring(string|binary A, int start)
聚合函数
count(*)count(expr)count(distinct expr[,expr_.])sum(col)sum(distinct col)avg(col)avg(distinct col)min(col)max(col)
表生成函数
explode(ARRAY array)explode(MAP map)explode(ARRAY a)json_tuple(STRING jsonStr,p1p2,…,pn)-parse_url_tuple(url,partname1,partname2,…,partnameN)以上是“Hive常用函数有哪些”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注开发云行业资讯频道！