Re: Re: sum function error URL: http://pan.baidu.com/s/1slFedyt

["apache_dev@163.com" <ap...@163.com>]

sorry,

  printScreen File(2.4M) is too large for mail server,could you download it in attachments url,  maybe attachments mail was intercepted ,please view mail subject





apache_dev@163.com
 
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 apache_dev@163.com <ap...@163.com>:
 
>
> 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
>
>
> apache_dev@163.com
>
> From: apache_dev@163.com
> 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);
>
>
>
>
>
>
> apache_dev@163.com
>