Hive进阶_内置函数

select round(45.926,2),round(45.926,1),round(45.926,0),round(45.926,-1),round(45.926,-2);

select lower(‘Hello World‘), upper(‘Hello World‘);
select length(‘Hello World‘),length(‘你好‘);
select concat(‘Hello‘,‘World‘);
select substr(‘Hello World‘,3);
select substr(‘Hello World‘,3,4);
select lpad(‘abc‘,10,‘*‘),lpad(‘abc‘,10,‘*‘);