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.
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.