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
精彩评论