Sorry, Kylin2.0 on HDP2.5.3
step printscreent in word,download url,please view in mail subject. [email protected] From: Billy Liu Date: 2017-07-26 22:51 To: dev Subject: Re: sum function error When you describe something is wrong, could you show the reproduce steps, versions, expected result and your analysis? For example, which kylin version, what measure and dimensions have been defined, what's your expected SUM result? What's the actual result. 2017-07-26 14:16 GMT+08:00 [email protected] <[email protected]>: > > 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] >
