kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "apache_dev@163.com" <apache_...@163.com>
Subject Re: Re: sum function error
Date Thu, 27 Jul 2017 02:57:28 GMT
sorry,

  printScreen File(2.4M) is too large for mail server,could you download it in attachments
url:

  



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 <apache_dev@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
>
Mime
  • Unnamed multipart/mixed (inline, None, 0 bytes)
View raw message