Hadoop Hive DOUBLE type question

Quick Hive/Hadoop question from a new user.

I have a DOUBLE column that has "1.8E8" for value, does it mean I reached the max value for DOUBLE?开发者_运维技巧

No. 1.8e8 is tiny. The maximum value for a IEEE 754 double is about 2.22e308.

No, it is the representation of decimal value in Hive.

1.8E8 --> 180000000

Refer this link for more details:

http://www.aptibook.com/discuss-technical?uid=tech-hive12&question=Double-type-in-Hive-%E2%80%93-Important-points