title: in hive casting of decimal to double is returning the exponential form rather than the non scientific form
body: <p>in hive casting of decimal to double is returning the exponential form rather than the non scientific form </p>
  
  <p>Example</p>
  
  <pre><code>hive&gt; select cast(12345678910.231 as double);
  OK
  1.2345678910231E10
  Time taken: 0.164 seconds, Fetched: 1 row(s)
  </code></pre>
  
  <p>but need the value 12345678910.231 stored as double.</p>
  
  <p><code>select cast(cast(12345678910.231 as double) as double);</code> also wont work and is similar as the above.</p>
  
  <p>I dont need the output format to be change using the prontf() UDF, rather i need the value to be stored and retrieved while querying as a non exponential form.</p>