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 aur...@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
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
@hive.apache.org
Subject: Specifying a double precision in HiveQL
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