Question about 2.x-staging integration test

[Xiaoyu Wang <wa...@jd.com>]

Hi developers!
I'm working on 2.x-staging  commit 
id:8fd28370a01f570f501927164f3dae2d0ca729e7
I change some cube desc : add some measures
When I running IT test. got a strange error:

  Failed tests:
ITIIQueryTest>ITKylinQueryTest.testCommonQuery:127->KylinTestBase.execAndCompQuery:400 
Incompatible data types: (table=query result of query10, 
col=TOTAL_ITEMS) expected:<[DECIMAL]> but was:<[BIGINT]>
ITIIQueryTest>ITKylinQueryTest.testCommonQuery:127->KylinTestBase.execAndCompQuery:400 
Incompatible data types: (table=query result of query10, 
col=TOTAL_ITEMS) expected:<[DECIMAL]> but was:<[BIGINT]>

the query10 sql is:

select test_cal_dt.week_beg_dt,sum(test_kylin_fact.price) as GMV
  , count(*) as TRANS_CNT , *sum(test_kylin_fact.item_count) as total_items*
  from test_kylin_fact
inner JOIN edw.test_cal_dt as test_cal_dt
  ON test_kylin_fact.cal_dt = test_cal_dt.cal_dt
  inner JOIN test_category_groupings
  ON test_kylin_fact.leaf_categ_id = 
test_category_groupings.leaf_categ_id AND test_kylin_fact.lstg_site_id = 
test_category_groupings.site_id
  inner JOIN edw.test_sites as test_sites
  ON test_kylin_fact.lstg_site_id = test_sites.site_id
  where test_kylin_fact.lstg_format_name='FP-GTC'
  and test_cal_dt.week_beg_dt between '2013-05-01' and DATE '2013-08-01'
  group by test_cal_dt.week_beg_dt

Why the column bigint sum in H2 database return decimal type? Any one 
meet the same problem?

Re: Question about 2.x-staging integration test

[Xiaoyu Wang <wa...@jd.com>]

Thanks hongbin!

I add some RAW measures on cube desc.
I will debug the code between the previously and the modified try to 
find the different!

在 2016年02月17日 10:15, hongbin ma 写道:
> ​did not find ​the official definition of SUM aggregation in ansi sql
> standards. but in https://msdn.microsoft.com/en-us/library/ms187810.aspx it
> seems the return type for bigint is bigint.
>
> BTW, what changes did you make? why it worked previously?
>
>
>
>

Re: Question about 2.x-staging integration test

[hongbin ma <ma...@apache.org>]

​did not find ​the official definition of SUM aggregation in ansi sql
standards. but in https://msdn.microsoft.com/en-us/library/ms187810.aspx it
seems the return type for bigint is bigint.

BTW, what changes did you make? why it worked previously?




-- 
Regards,

*Bin Mahone | 马洪宾*
Apache Kylin: http://kylin.io
Github: https://github.com/binmahone