title: Cast Scientific number to Decimal in Hive
body: <p>I want to cast the number which has scientific notation to Decimal in Hive, But I am getting wrong output. Where I am doing wrong..</p>
  
  <p>Below is my query to test.</p>
  
  <pre><code>select cast(-1.36666E2 as decimal(6,1))
  </code></pre>
  
  <p>I am expecting the output to be <strong>-1.36666</strong> . But I got <strong>-136.7</strong></p>