title: Decimal precision in hive
body: <p>I want to add the decimal precision to be set for the values</p>
  
  <p>Example: </p>
  
  <pre><code>select 1*1.00000;
  </code></pre>
  
  <p>output: <code>1.0</code></p>
  
  <p>Even tried with cast</p>
  
  <pre><code>select cast(cast(1*1.0000 as double) as decimal(5,2))
  </code></pre>
  
  <p>output: <code>1</code></p>
  
  <p>I want the results to be displayed as <code>1.000</code>. Is there any way to do so in hive?</p>