try
select sum(sales) from salestemp where sales is not null;
On Thu, Jul 24, 2014 at 11:10 PM, Abhishek Gayakwad
wrote:
> I am trying to aggregate one column of decimal type, which is returning me
> null. If I cast this column to double it returns me some value. following
> are the steps to re
I am trying to aggregate one column of decimal type, which is returning me
null. If I cast this column to double it returns me some value. following
are the steps to recreate this scenario.
CREATE TABLE salestemp(sku int, sales decimal);
LOAD DATA LOCAL INPATH '0
