hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aurora Skarra-Gallagher <aur...@yahoo-inc.com>
Subject Specifying a double precision in HiveQL
Date Thu, 24 Feb 2011 19:31:17 GMT
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
Mime
View raw message