HIVE decimal 2 precision

Question

In my hive table the actual values looks as below.

 100
 200.345
 12.365

I want to have them looks like:

 100.00
 200.34
 12.36

How it can be possible?

Answer 1

You should declare as decimal(5,2). Hive Decimals .

The syntax is DECIMAL(precision, scale). Precision means the number of digits of this number including the digits after the dot.