Hive Cast the Scientific number to Decimal
<p>SELECT cast(123452.256 as BIGINT);</p>

<p>123452</p>

<p>The above query gives me the integer value,What if i want the decimal part too.Is there any way to cast that?</p>