Photo maybe cann't open.
I run insight:
select sum(TEM.C) from TEM,result is wrong
but run:
select sum(TEM.B) from TEM,result is right
[email protected]
From: [email protected]
Date: 2017-07-26 11:47
To: dev
Subject: sum function error
Hi,
when i run sum function,get a error result:
Hive table,no lookup table
create table tem(a varchar(1),b bigint,c bigint);
insert into tem values('A',null,1);
insert into tem values('A',1,1);
insert into tem values('A',2,1);
insert into tem values('B',3,1);
insert into tem values('B',1,1);
insert into tem values('C',4,1);
[email protected]
