1.类型转换函数
select cast("5" as int)
2.数学运算函数
select round(5.4)
select greatest(3,5,6)
3.字符串函数
select substr("abcdefg",2)
4.时间函数
select current_timestamp;
select current_date;
5.其他
explode(subjects)
去除列表
lateral view
类似于join
例子
select id,name,tmp.sub
from t_stu_subject lateral view explode(subjects) tmp as sub;