format_number
hive> select format_number(pow(10,8),'##################.##');
100000000decimal
hive> select cast (pow(10,8) as decimal(20, 2) );
100000000
Toggle site
Catalog
You've read0%
format_number
hive> select format_number(pow(10,8),'##################.##'); |
decimal
hive> select cast (pow(10,8) as decimal(20, 2) ); |