Re: Specifying a double precision in HiveQL

2011-03-15 Thread Amareshwari Sri Ramadasu
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

Specifying a double precision in HiveQL

2011-02-24 Thread Aurora Skarra-Gallagher
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

RE: Specifying a double precision in HiveQL

2011-02-24 Thread Paul Yang
@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