You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Amareshwari Sri Ramadasu <am...@yahoo-inc.com> on 2011/03/15 11:59:03 UTC

Re: Specifying a double precision in HiveQL

You can use UDF round(x,d) which rounds of x to d decimal places

Thanks
Amareshwari

On 2/25/11 1:01 AM, "Aurora Skarra-Gallagher" <au...@yahoo-inc.com> wrote:

Hi,

I have a Hive query that has a statement like this "(sum(itemcount) / count(item))". I want to specify only two digits of precision (i.e. 53.55). The result is stored inside of a string, not its own column, so I'd need to set the precision in the statement. Is this possible?

Thanks,
Aurora