https://community.cloudera.com/t5/Support-Questions/in-hive-casting-of-decimal-to-double-is-returning-the/m-p/209232#M171188 <P>hive&gt; select cast(12345678910.231 as double); </P><P>1.2345678910231E10 </P><P>Time taken: 0.164 seconds, Fetched: 1 row(s) </P><P>but need the value 12345678910.231 stored as double.</P><P>select cast(cast(12345678910.231 as double) as double); also wont work and is similar as the above.</P><P>I dont need the output format to be change using the printf() UDF, rather i need the value to be stored and retrieved while querying as a non exponential form.</P> Thu, 10 Aug 2017 16:11:31 GMT ekharshavardhan 2017-08-10T16:11:31Z