title: Hive Converting from Double to String Not in Scientific
body: <p>I have a table with a column double type, and I am trying to convert that from double to string. </p>
  
  <p>However, when I use the cast command, it "smartly" convert that into scientific notation.  like below: </p>
  
  <pre><code>select 
      number, 
      cast(number as string), 
  from ...
  </code></pre>
  
  <p>it looks like </p>
  
  <pre><code>number     c1_
  9999999902  9.999999902E9
  9999999902  9.999999902E9
  9999999902  9.999999902E9
  9999999902  9.999999902E9
  9999999909  9.999999909E9
  </code></pre>
  
  <p>Can anyone show me how to avoid converting that into scientific and keep the raw text? </p>