title: Hive to avoid converting to Scientific
body: <p>I have a value conversion error as below in hive. How to solve it.</p>
  
  <pre><code>select 28200*100000;
  select cast(28200*100000 as BIGINT);
  output: -1474967296
  </code></pre>
  
  <p>Actual output should be</p>
  
  <pre><code>2820000000
  </code></pre>