Hive-Hive函数

你拓哥

于 2022-11-22 21:24:24 发布

阅读量341

点赞数

分类专栏： Hive 文章标签： hive

本文链接：https://blog.csdn.net/nituoge/article/details/103612841

版权

Hive 专栏收录该内容

8 篇文章

订阅专栏

转移符号\
Function 函数
build-in 内置函数
show functions;
desc function upper;
desc formatted function upper;
desc extended function upper;
UDF User Defined Function 用户自定义函数

常用的时间函数

select * from dual;
select current_date from dual;
select current_timestamp from dual;
select unix_timestamp() from dual;
select unix_timestamp(‘2019-12-31 20:10:10’) from dual;
select unix_timestamp(‘20191231 20:10:10’,‘yyyyMMdd HH:mm:ss’) from dual;

desc extended function from_unixtime;
desc extended function to_date;
desc extended function year;
desc extended function month;
desc extended function day;
desc extended function hour;
desc extended function minute;
desc extended function second;

desc extended function date_add;
desc extended function date_sub;