https://community.cloudera.com/t5/Support-Questions/in-hive-casting-of-decimal-to-double-is-returning-the/m-p/209233#M171189 <A rel="user" href="https://community.cloudera.com/users/26259/ekharshavardhan851.html" nodeid="26259">@sai harshavardhan</A><P>The value that you are receiving is as expected, this sample java code show the info. If you are wanting to get the exact value as an output, you should convert that value to string.</P><P>import java.lang.*; </P><P>public class DoubleDemo </P><P>{ </P><P> public static void main(String[] args) </P><P>{ </P><P> double d = 12345678910.231; </P><P>System.out.println("Value of d = " + d); </P><P> }</P><P>}</P> Fri, 11 Aug 2017 04:26:22 GMT quadoss 2017-08-11T04:26:22Z