Question on sum(float column)

2011-05-13 Thread M.R. Muthukumar
When I do a sum of a float column, result is represented in real Number format like 3.6541529954550403E8, is there a way to get the result as a regular number with 2 decimal digits, I did try round function which didn't help. Thanks for the help.

Question table visibility in hive

2010-11-12 Thread M.R. Muthukumar
Environment Info : SLES10SP1, Hadoop 0.20.2, Hive 0.6.0 This is the scenario : 1. start hive shell from /root/tmp directory and create a table and quit out of hive. 2. start hive shell from /root directory, show tables does not show the created table, this new table is not visible at all.